Wizard to launch the OLAP report To analyze the data dynamically
using OLAP PivotTable, you can choose OLAP Data Analysis from PowerCom
in the Menu Bar.
By following the steps showing bellow you will popup and
analyze the data using The Pivot Table tool in the Excel spreadsheet
form:
Step 1. Click Browse to Allocate
the Analysis File you want to export the data into (the file must be
.csv), and click Next button.
Step 2. Available dimensions will
be displayed in the left list box; choose the row dimensions you want
to view and click arrow button; the dimensions you select will be in
the right list box, click Next Button.
Step 3. From this window select
column dimensions you want to view and click Next button.
Step 4. Click Finish Button.
About PivotTable reports
A PivotTable report is an interactive table that you can
use to quickly summarize large amounts of data. You can rotate its rows
and columns to see different summaries of the source data, filter the
data by displaying different pages, or display the details for areas
of interest.
How PivotTable reports organize data:
Fields and items
A PivotTable report contains fields, each of which corresponds to
a column (or OLAP dimension) in the source data and summarizes multiple
rows of information from the source data. Fields in a PivotTable report
list items of data across rows or down columns. The cells where the
rows and columns intersect show summarized data for the items at the
top of the column and the left side of the row. For example “Gender”,
“Age” and “Mstatus” can be a columns dimensions,
and “Mprice” can be a row dimension.
Data fields and cells
A data field, provides the values that are summarized in the PivotTable
report. For example the “Vote Count” as Data field.
Summary functions
To summarize the data field values, PivotTable reports use summary
functions, such as Sum, Count, or Average. These functions also provide
subtotals and grand totals automatically, where you choose to show
them.
Viewing details
In most PivotTable reports, you can view the detail rows from the
source data that make up the summary value in a particular data cell.
Changing the layout
By dragging a field button to another part of the PivotTable report,
you can view your data in various ways and calculate different summarized
values.
Graphical views of PivotTable data
A PivotChart report is an interactive chart that you can use to view
and rearrange data graphically, in a similar manner to a PivotTable
report. A PivotChart report always has an associated PivotTable report
in the same workbook, and includes all of the source data from the
associated report. And like a PivotTable report, a PivotChart report
has field buttons that you can use to display different data and change
the layout.
Elements
of a PivotTable report
Row fields
Fields from the underlying source data that are assigned a row orientation
in a PivotTable report. A PivotTable report that has more than one
row field has one inner row field, the one closest to the data area.
Any other row fields are referred to as outer row fields. For example,
“Gender”, “Age” and “Mstatus”.
Column field
A field that's assigned a column orientation in a PivotTable report.
A PivotTable report can have multiple column fields just as it can
have multiple row fields. Most indented format PivotTable reports
do not have column fields. For example “Mprice”
Page field
A field that's assigned to a page, or filter, orientation. When you
click a different item in a page field, the entire PivotTable report
changes to display only the summarized data associated with that item.
Page field item
Each unique entry or value from the field, or column, in the source
list or table becomes an item in the page field list.
Data field
A field from a source list or database that contains data to be summarized.
For example “Vote count”
Data area
The part of a PivotTable report that contains summary data. The cells
of the data area show summarized data for the items in the row and
column fields. Each value in the data area represents a summary of
data from the source records, or rows
About adding and removing fields
Depending on how the person who created a PivotTable list
has set up the data, you might be able to display additional data or
remove data that you don't want to view or summarize.
Viewing the fields available to the PivotTable list
Use the field list to view the list of fieldsets and fields that are
available from the source data, and to add fields to the row, column,
filter, data, and detail areas of the PivotTable list. In the field
list, the fields that are not bold are available but not yet displayed
in the PivotTable list. The bold fields are already displayed. You
can scroll and click the expand indicators next to the fieldsets to
show or hide fields in the field list.
Adding fields to the detail area
Use detail fields to display all of the available detail data and
see what data is available to be summarized. When you add fields to
the detail area, you display all of the detail records from the source
data for the fields. Field names become column labels, and the detail
records are displayed in rows below the column labels.
Adding fields to the row or column area
Use row and column fields to summarize and compare data. These fields
display the unique items of data within a field down rows or across
columns. The cell at each row and column intersection summarizes the
data for an item.
Adding fields to the data area
Data fields provide the values to be summarized in the PivotTable
list. When you add a field to the data area, the values from the field
are summarized for the row and column field items.
Adding fields to the filter area
A filter field is similar to a page field in a Microsoft Excel PivotTable
report. Use filter fields to confine the view to a particular part
of the available data. When you select an item in a filter field,
data is displayed and calculated only for that item. For example,
if you add a Region filter field, you can have the PivotTable list
display and calculate data for the regions you select.
Removing fields
To eliminate data that you don't want to see or summarize, you can
remove fields from the PivotTable list layout. Removing a field does
not remove it from the available source data. A field that you remove
is no longer displayed in the PivotTable list, but it remains available
in the field list for viewing
Moving fields
After you add a field to a PivotTable list, you can move it to other
areas. When you move a field, you change the layout of the PivotTable
list, and you change the data that's displayed and the summaries that
are calculated.
Viewing information about fields
You can view information about fields in a PivotTable list, including
information about the field in the source database from which the
data is taken and the type of data that the source database supplies
for the field.
The applications for PowerCom are
only limited by your imagination!
