User guide
Create a New Analysis
-
On the left nav bar -- click on Administration, then on Create New Analysis
-
Under data source -- choose the data source (OLAP server) that has
the cubes for your project (usually there should be only one, named
something like "projectdefault")
-
The app will automatically pick up the default catalog (which means
the particular OLAP database in the OLAP server that has project data)
-
Don't worry too much about "Data Source" or "Catalog" at this
point, pick the default that's already there -- but focus more on the
particular OLAP cube from which you want to report -- which you select
under the dropdown list "Cube"
-
Once you select the cube, the app will present a list of all dimensions available
in the cube. It will pick up 1 each for column and row,
and put the rest in the "Filter" section -- here, think
of a typical cross-tab report, and figure out which dimensions
you want on the column and row. Here's how you do it:
-
First, move the dimension(s) from the Filter section to Row or Column. Next to each dimension you will see two icons (the row icon) and (the column icon)
-
To move a dimension to row, click on
-
To move a dimension to column, click on
-
To move a dimension from Row/Column back to Filter, click on the (the filter icon)
-
To select dimension level for a dimension, click on the dimension. You will see a list of all dimension levels available in the dimension.
-
To expand dimension level, click on
-
To collapse dimension level, click on
-
To move dimension level position :
-
Check dimension level(s) from the list to select. Selected dimension level(s) will appear in analysis.
-
Once you have the right dimensions placed under Row and Column --
click on OK -- this will process your input for a few seconds -- and
result into a bar graph (and associated table) displaying the data for
the dimensions you chose
-
Click on "Save Analysis As" button from the top button menu bar (2nd button from left)
-
This brings up a page where you define the following:
-
Save as public or private
-
saving as "private" means that the analysis is viewable only by
you. If you don't have it already, the app will create a private folder
in the left nav under your username, and you will see the analysis
listed under it. You will choose this option when you want to "play
around" with the data on your own before sharing it with the rest of
the team members.
-
saving as "public" analysis means it is viewable by everyone who
has access to this project. You will choose this option when you want
to share your analysis with the rest of the project team.
-
caveat: Best practice is to use only alphanumerics (letters and numbers only, no symbols if possible).
-
Once you save, you should see the analysis listed in the left nav bar under the appropriate folder
Modify an Analysis
When you bring up any analysis, there is a button menu displayed up top of the chart/table as:
This provides you several options to configure the look and feel of the
display, as well as apply the relevant filters to display just the data
that you want to focus on. Here is a brief summary of these button
functionalities:
(Create New Analysis)
Takes you through a page where you select the OLAP server, OLAP
database, and the cube from which you want to create an analysis. Once
the cube is selected, it will list all the dimensions in the cube, and
you can arrange what goes on the row and column, and what filters you
want to set for the report.
(Change Datasource)
Allows user to change datasource of the analysis (i.e.- connect to a different server, different cube). The datasources are configured by a project administrator via the Configure Datasource link under Administration
(Save Analysis)
Saves the analysis overwriting the existing copy. Best practice is
to use only alphanumerics (letters and numbers only, no symbols if
possible).
(Save Analysis As)
Saves the analysis under a different name. This is useful
for moving an analysis from private to public area, or vice
versa. Best practice is to use only alphanumerics (letters
and numbers only, no symbols if possible).
(Delete Analysis)
(Configure Print Settings)
(Print this Page via PDF)
(Start Excel)
Exports the current analysis as an Excel file. The chart is
exported as an image file, and the table is brought over as-is
preserving the numerical cells, so you can apply additional calculation
formula in excel.
(Show Chart)
(Show Table)
(Chart Config)
Brings up chart configuration settings in the left navigation pane,
where you can change the chart settings such as chart size, title,
font, axes labels, etc. By default, the application sets these up to
project defaults, and chart size is set according to your browser
display size. This option allows you to overwrite all that.
(Show MDX Editor)
Displays the MDX syntax for the current analysis display. This is
useful if you want to overwrite the MDX query with a customized query.
More useful for advanced OLAP users.
(Sort Settings)
-
Sorts the current measures in ascending order. Clicking again sorts
descending, and if you click again, goes back to nautral order.
-
Next to each measure in the table, you will see normally see a blue
dot icon (if the measures are being displayed in their natural order).
-
Clicking on the blue dot first does an ascending sort on that
particular measure attribute, and displays a red arrow tip in the
direction of the sort
-
Clicking on the red arrow again does the sort in descending arrow, and the red arrow flips
-
Clicking on the red arrow again brings the data back to the natural order, and the blue dot is displayed back
Chart Selection Dropdown List
This is a list of all the different chart representation supported
by the application. Choose the desired chart type and click the Apply
button to change the chart type.
(Show Parent Members)
This applies to table view only. When you are viewing data in a
dimension with multiple levels of hierarchy (for e.g. a geographical
location which may have hierarchies of region-state-metro area-city,
etc.), this button toggle between displaying dimension members with or
without their parent members. This is useful when you are using the
"Drill Replace" feature (described below)
(Hide Spans)
This also applies to table view only when displaying dimension with
multiple hierarchy levels. It toggles between parent member repeated in
every row, versus parent members only displayed for the span.
(Suppress Empty Rows/Columns)
(Swap Axes)
Moves dimensions from X axis to Y, and Y from X
(Drill Position)
Turning this button on enables drilling from a high level member to
members in lower levels, while still showing the parent level members.
For e.g in a geographic location dimension, if you drill down from
region to city level while Drill Position button is on, you will see
the city level information as well as the region level information.
When this mode is on, you will see a blue + sign next to the parent
level dimension member which expands when you click on it, displaying
the child members.
(Drill Replace)
Turning this button on also enables drilling from a high level
member to members in lower levels, the big difference here is that it
only shows the children members, and not the parent members. For e.g in
a geographic location dimension, if you drill down from region to city
level while Drill Replace button is on, you will only see the city
level information, and the region level information will be hidden.
When this mode is on, you will see a red arrow sign next to the
dimension members. The direction of the arrow indication whether you
are going "down" from parent level to children level, or if you are
going "up" from children to parent level.
(Drill Through)
-
This features enables you to drill through a measure value
and get the detailed data underneath it. For example, with
this feature enabled, you can click on a count of customers,
and get a list of the underlying customer identification
numbers (and other associated information such as their
account number, name, email, etc.) -- so, it is very helpful
with list cutting type of features, or just looking at details
underneath any summarized data.
-
Drill through is a feature that must be enabled in the OLAP cubes
first. If the OLAP cube has drillthrough enabled, clicking on this
button will show a blue arrow next to the measures. When you click on
the blue button, it will query the underlying database, and bring up
screens that list the individual records. It can also be implemented to
produce a downloadable file instead of displaying the detailed records
on the web page.
|
|