MDX Usage : select \[<Dimension name>\].\[<Hierarchy name\] on columns from \[<Cube name>\]
MDX Example: select \[Category\].\[All Categories\] on columns from \[My Cube\] !mdx.png!
You should get something similar to this back:
- Log in to the Pentaho User Console using a web browser: http://localhost:8080/pentaho
- Select File, New, Analysis View
- Select the appropriate schema and cube that you published
- Click OK
Your view will display in a tab to the right
A word on editing and then re-publishing or saving a Schema
Please note that any changes/updates/additions made to the ROLAP Analysis Schema using Schema Workbench or another editor (such as Design Studio or text editor) will require a refresh of the Pentaho Solution Repository and a refresh of the Mondrian Schema Cache. This can be done in the Pentaho User Console.
- Log in to the Pentaho User Console with an Admin equivalent ID
- Tools, Refresh, Repository Cache
- Tools, Refresh, Mondrian Schema Cache
These steps ensure that you are using the latest versions of the ROLAP schema when creating or using Pentaho Analysis Views.
Manually Creating the Pentaho Analysis View Action Sequence (advanced)
Follow the instructions below to create the action sequence :manually that will display a Pentaho Analysis View. (This is a way where you can create the Pentaho action sequence manually to create the Pentaho Analysis View.) The advantage here is that you can have added control over the Pentaho Analysis query and the tool bar buttons available in the Pentaho Analysis Viewer. Users who are already familiar with Pentaho Design Studio and parameterized queries will be able to work with this section more effectiely.
- In the Pentaho Design Studio, select your solution path, right-click the folder, and select BI Platform > New Action Sequence.
- Enter the name for action sequence
- Select Create Analysis View in the Template drop down and click Finish
- Select Analysis View under Process Actions.
- Modify the Data Model and Data Source parameters accordingly. The Data Model is the path location and XML file you saved in Step 1 under Publishing your Analysis Schema Model on the Pentaho Open BI Server. The Data Source is the JNDI name you used when creating your data source in the section, Configuring your RDBMS JNDI data source on your application server, or the name you gave the data source in the Admin Console when using version 2.0 BI Server.
- Leave "default" as the query, later you can copy the MDX from the Analysis View MDX editor window and paste in
this query dialog to create parameterized and more advanced Pentaho Analysis Views.
- Save and test your Pentaho Analysis View using the URL with the appropriate solution= and path= directory names where you saved your .xaction and file.mondrian.xml files. You can use the TEST tab in Design Studio or copy and paste the URL into a browser or access it from the Pentaho Solution Repository via the Pentaho User Console.