Pentaho Analysis Viewer (Jpivot)
Pentaho Analysis Viewer (Jpivot)
Contents:
The Jpivot Buttons
The above menu are the buttons that are available to you when you use Jpivot to display your MDX query results. You can see the name of each button by hovering your mouse pointer over it. Note that some of these options will display their information at the bottom of the page, so you may have to scroll down to see them.
Open OLAP Navigator
This button allows you to explore your cube. It will display all of the measures and dimensions, and it will allow you to select the items you want to see on your report. When you click the button the following screen comes up (with your dimensions and measures of course).
When you click on one of the dimensions the following screen will come up, which allows you to select the items that you want to see.
The buttons at the bottom are:
- None - select none
- Flat/Group - This toggles between grouping the items (to make the list easier to read) or just showing everything as a flat list
- OK - accept your changes and return to the OLAP Navigator
- Cancel - cancel any changes you have made
Move dimension to Columns area
Move dimension to Rows area
Move dimension to Filters area
Move dimension up/down in the current area
Show MDX Editor
This button shows the editor that allows you to type in your own MDX query. MDX is similar to SQL, but is designed to ask questions of your cube instead of your database. NOTE: MDX is not SQL, so some of the ways that you organise queries in SQL will not work in MDX.
The MDX editor will show you the query that is currently generating your Jpivot report.
Config OLAP Table
This button brings up the above options.
- Sort mode - has the following selections
- Keep Hierarchy Ascending
- Keep Hierarchy Descending
- Break Hierarchy Ascending
- Break Hierarchy Descending
- Top Count
- Bottom Count
- Number of rows for Ranking - Applies to the Top Count and Bottom count selections above
- Show Member properties - Will show additional details if they are defined in your cube
Show Parent Members
This button toggles between showing a hierarchical view of the data or a flat view. Basically it will insert column headings above your data when you have drilled into your hierarchy.
Hide Spans
This button will toggle between having all of the row descriptors visible or not. You may want to turn this on just before you export your data to Excel. It works when the you have 'Show Parent Members' on.
Show Properties
This button will show additional details if they are defined in your cube. This can also be set by selecting 'Show Memberproperties' in the 'Config OLAP table' menu.
Suppress Empty Rows / Columns
This toggles the display of empty rows/columns. This is especially useful for tables that contain a lot of blank data.
Swap Axes
Will move the columns to the rows and the rows to the columns, effectively rotating the result by 90°.
Drill options
There are four main drill options:- Drill Member: drill across multiple members in one click
- Drill Position: drill only where you click
- Drill Replace: drill into the data and only see the items you have selected to dig into
- Drill Through: drill into the raw fact information so you can see the details behind the numbers that you are being presented
Drill Member
This allows you to drill across multiple members in one click. For example if you wanted to expand all of the 2005 data you would select this one.
See the Before and After below — with just one click I expanded all of the 2005 Members.
Before:
After:
Drill Position
Same as Drill Member, but this will just drill where you are clicking. So if you want to just drill into the element you are selecting this is the one for you.
See below for a Before and After view — notice how just the 2005 member that I selected (under APAC) is expanded, but not the data under EMEA.
Before:
After:
Drill Replace
This one allows you to drill into the data and only see the items you have selected to dig into. The view is replaced by the data you selected. This is useful if you only want to see this data and don't want to be distracted by the rest.
See below of a similar example to what we have above. Again, I selected 2005 under APAC and I got just the Q1 and Q2 data.
Before:
After:
Drill Through
This allows you to drill into the raw fact information so you can see the details behind the numbers that you are being presented. This is shown as a separate Drill Through Table below the main analysis table. CAUTION: if there are lots of rows, it will return lots of pages.
Before:
After:
Chart options
Analysis data may be visualised with charts.Show Chart
This function will turn on the chart function. This will use the default settings for the chart function.
Chart Config
This button brings up the following menu where you can configure the chart(s) that show up from your report.
Chart Type
The following are the chart types that are available:
