Wiki source code of Pentaho Analysis Viewer (Jpivot)

Hide line numbers
  1: 1 Pentaho Analysis Viewer (Jpivot)
  2: 
  3: #startfloatingbox()
  4: *Contents:* \\
  5: #toc("2" "6" "false")
  6: #endfloatingbox()
  7: 
  8: 1.1 The Jpivot Buttons
  9: 
 10: {image:Jpivotbuttons.png}
 11: 
 12: 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.
 13: 
 14: 1.1 Open OLAP Navigator
 15: 
 16: {image:OLAPnavigatorbutton.png} 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).
 17: 
 18: {image:olapnavigator.png}
 19: 
 20: 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.
 21: 
 22: {image:olapnavigatorelement.png}
 23: 
 24: The buttons at the bottom are:
 25: 
 26: * None - select none
 27: * Flat/Group - This toggles between grouping the items (to make the list easier to read) or just showing everything as a flat list
 28: * OK - accept your changes and return to the OLAP Navigator
 29: * Cancel - cancel any changes you have made
 30: 
 31: On the main OLAP Navigator screen, the buttons allow you to do the following:
 32: 
 33: {image:olapnavigatormoveitemtocolumns.png} Move dimension to Columns area
 34: 
 35: {image:olapnavigatormoveitemtorows.png} Move dimension to Rows area
 36: 
 37: {image:olapnavigatormoveitemtofilters.png} Move dimension to Filters area
 38: 
 39: {image:olapnavigatormoveupordown.png} Move dimension up/down in the current area
 40: 
 41: 1.1 Show MDX Editor
 42: 
 43: {image:MDXeditorbutton.png} 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.
 44: 
 45: The MDX editor will show you the query that is currently generating your Jpivot report.
 46: 
 47: {image:MDXqueryeditor.png}
 48: 
 49: 1.1 Config OLAP Table
 50: 
 51: {image:configOLAPtable.png}
 52: 
 53: {image:OLAPtablebutton.png} This button brings up the above options.
 54: 
 55: * Sort mode - has the following selections
 56: ** Keep Hierarchy Ascending
 57: ** Keep Hierarchy Descending
 58: ** Break Hierarchy Ascending
 59: ** Break Hierarchy Descending
 60: ** Top Count
 61: ** Bottom Count
 62: * Number of rows for Ranking - Applies to the Top Count and Bottom count selections above
 63: * Show Member properties - Will show additional details if they are defined in your cube
 64: 
 65: 1.1 Show Parent Members
 66: 
 67: {image:parentparametersbutton.png} 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.
 68: 
 69: 1.1 Hide Spans
 70: 
 71: {image:hidespansbutton.png} 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.
 72: 
 73: 1.1 Show Properties
 74: 
 75: {image:propertiesbutton.png} 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.
 76: 
 77: 1.1 Suppress Empty Rows / Columns
 78: 
 79: {image:suppressemptyrowsbutton.png} This toggles the display of empty rows/columns. This is especially useful for tables that contain a lot of blank data.
 80: 
 81: 1.1 Swap Axes
 82: 
 83: {image:swapaxesbutton.png} Will move the columns to the rows and the rows to the columns, effectively rotating the result by 90&#176;.
 84: 
 85: 1.1 Drill options
 86: 
 87: There are four main drill options:
 88: 
 89: * Drill Member: drill across multiple members in one click
 90: * Drill Position: drill only where you click
 91: * Drill Replace: drill into the data and only see the items you have selected to dig into
 92: * Drill Through: drill into the raw fact information so you can see the details behind the numbers that you are being presented
 93: 
 94: 1.1.1 Drill Member
 95: 
 96: {image:drillmemberbutton.png} 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.
 97: 
 98: See the Before and After below &mdash; with just one click I expanded all of the 2005 Members.
 99: 
100: Before:
101: 
102: {image:drillmemberbefore.png} 
103: 
104: After:
105: 
106: {image:drillmemberafter.png} 
107: 
108: 1.1.1 Drill Position
109: 
110: {image:drillpositionbutton.png} 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.
111: 
112: See below for a Before and After view &mdash; notice how just the 2005 member that I selected (under APAC) is expanded, but not the data under EMEA.
113: 
114: Before:
115: 
116: {image:drillpositionbefore.png} 
117: 
118: After:
119: 
120: {image:drillpositionafter.png} 
121: 
122: 1.1.1 Drill Replace
123: 
124: {image:drillreplacebutton.png}
125: 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.
126: 
127: 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.
128: 
129: Before:
130: 
131: {image:drillreplacebefore.png} 
132: 
133: After:
134: 
135: {image:drillreplaceafter.png} 
136: 
137: 1.1.1 Drill Through
138: 
139: {image:drillthroughbutton.png} 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.
140: 
141: Before:
142: 
143: {image:drillthroughbefore.png} 
144: 
145: After:
146: 
147: {image:drillthroughafter.png}
148: 
149: 1.1 Chart options
150: 
151: Analysis data may be visualised with charts.
152: 
153: 1.1.1 Show Chart
154: 
155: {image:showchartbutton.png} This function will turn on the chart function. This will use the default settings for the chart function.
156: 
157: 1.1.1 Chart Config
158: 
159: {image:chartconfigbutton.png} This button brings up the following menu where you can configure the chart(s) that show up from your report.
160: 
161: {image:chartconfig.png} 
162: 
163: 1.1.1.1 Chart Type
164: 
165: The following are the chart types that are available:
166: 
167: {image:charttype.png}
168: 
169: 1.1.1.1 Enable Drill Through
170: 
171: Will allow you to select a component of the chart and see the details that see underneath it. Similar to the 'Drill Through' function above.
172: 
173: 1.1.1.1 Remaining Functions
174: 
175: Relatively self-explanatory formatting functions.
176: 
177: 
178: 1.1 Other resources
179: 
180: Pentaho have their own [users' guide to Pentaho Analysis Viewer>http://wiki.pentaho.com/display/PentahoDoc/Introduction+to+Pentaho+Analysis+Viewer+(JPivot)]
Pentaho Analysis Viewer (Jpivot)

Wiki source code of Pentaho Analysis Viewer (Jpivot)

BizCubed

Search

Quick Links

Recently Created

Recently Modified
