Open Source Web Application for OLAP Reporting

Home | OpenI | Team | Community | Download | News | Wiki

SourceForge.net Logo

User guide

Create a New Analysis

  1. On the left nav bar -- click on Administration, then on Create New Analysis

  2. 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")

  3. The app will automatically pick up the default catalog (which means the particular OLAP database in the OLAP server that has project data)

  4. 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"

  5. 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 row.png (the row icon) and column.png (the column icon)

      • To move a dimension to row, click on row.png

      • To move a dimension to column, click on column.png

    • To move a dimension from Row/Column back to Filter, click on the filter.png (the filter icon)

  6. 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 drill-member-expand.gif

    • To collapse dimension level, click on drill-member-collapse.gif

    • To move dimension level position :

      • Click on blue dot icon cut.png next to dimension level. The blue dot icon will be changed to red dot icon (select this red dot icon to cancel move operation)

      • Click on paste before icon paste-before.png or paste after icon paste-after.png

    • Check dimension level(s) from the list to select. Selected dimension level(s) will appear in analysis.

  7. 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

  8. Click on "Save Analysis As" button save-as-up.png from the top button menu bar (2nd button from left)

  9. 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:

    new-up.png new-up.png save-up.png save-as-up.png trash-up.png print-config-up.png print-up.png excel-up.png chart-down.png properties-down.png chart-config-up.png mdx-edit-up.png sort-asc-up.png level-style-up.png hide-spans-up.png non-empty-up.png swap-axes-up.png navi-position-down.png navi-replace-up.png navi-through-up.png

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:

new-up.png (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.

data-source-up.png (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-up.png (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-as-up.png (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).

trash-up.png (Delete Analysis)

    Deletes the currently displayed analysis.

print-config-up.png (Configure Print Settings)

    Brings up print configuration settings.

print-up.png (Print this Page via PDF)

    Prints the current analysis as a PDF document.

excel-up.png (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.

chart-down.png (Show Chart)

    Toggle button to turn chart display on or off.

properties-down.png (Show Table)

    Toggle button to turn table display on or off.

chart-config-up.png (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.

mdx-edit-up.png (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-asc-up.png (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 sort-natural.gif (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 sort-current-up.gif in the direction of the sort

  • Clicking on the red arrow again does the sort in descending arrow, and the red arrow flips sort-current-down.gif

  • Clicking on the red arrow again brings the data back to the natural order, and the blue dot sort-natural.gif 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.

level-style-up.png (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-up.png (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.

non-empty-up.png (Suppress Empty Rows/Columns)

    This allows you to suppress the column/rows that have all empty (zero) values

swap-axes-up.png (Swap Axes)

    Moves dimensions from X axis to Y, and Y from X

navi-position-down.png (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.

navi-replace-up.png (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.

navi-through-up.png (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.

© Copyright 2005, Loyalty Matrix, Inc.
All trademarks are the property of their respective owners.