An OLAP view can retrieve data from a Mondrian connection. For more information on Mondrian connections, refer to Editing a Mondrian Connection.
To create an OLAP view with a local Mondrian connection:
| 1. | Click View > Repository. |
The repository page appears.
| 2. | In the Folders panel, navigate to Organization > Organization > Analysis Components > Analysis Views. |
| 3. | Right-click the folder and select Add Resource > OLAP View. |
The Name the View page appears and prompts you to provide a name for the new view.
| |
| Name the View Page |
| 4. | Enter a name and description for the new view. The Resource ID field is auto-generated when you type in the Name field. After it is saved, it can’t be changed. |
| 5. | Click Next. |
The Locate Mondrian Client Connection Source page appears and prompts you to select or create a local Mondrian connection.
| |
| Locate Mondrian Client Connection Source Page |
| 6. | Click either: |
| • | Define a Mondrian Client Connection in the next step. |
| • | Select a Mondrian Client Connection from the repository. |
Then click Browse, navigate to the connection you want, and click Select.
| 7. | Click Next. |
If you chose to define a new Mondrian connection, the Set Connection Type and Properties page appears and prompts you to define a connection.
| Set Connection Type and Properties Page |
| |
| 8. | To change the type of the connection, select a connection type from the Type drop-down and complete the fields. Otherwise, enter the requested information. For details see Creating a Mondrian Connection. |
| 9. | To chose a location for the connection, click Browse, navigate to a folder, and click Select. |
| 10. | Click Next. |
The Locate OLAP Schema page appears and prompts you to upload an OLAP schema or select one from the repository.
| Locate OLAP Schema Page |
| |
| 11. | Click either: |
| • | Upload a Local File to select a file from your local computer. |
Then click Browse, navigate to select the file you want, and click Select.
| • | Select a resource from the Repository to select an existing schema. |
Then click Browse, navigate to select the schema, and click Select.
| 12. | Click Next. |
The OLAP Schema Resource page appears.
| OLAP Schema Resource Page |
| |
If you chose to upload a new file, the fields are editable. Enter the requested information. For details, refer to Working with OLAP Schemas.
| 13. | Click Next. |
The Locate Data Source page appears and prompts you to create or select a data source.
| Locate Data Source Page |
| |
| 14. | Click either: |
| • | Define a Data Source in the next step to add a data source. |
| • | Select a Data Source from the repository to select a data source from the repository. |
Then click Browse, navigate to the data source you want to use, and click Select. Click Next and skip to step 18.
| 15. | Click Next. |
If you chose to create a new data source, the Set Data Source Type and Properties page appears.
| Set Data Source Type and Properties Page |
| |
| 16. | Enter the requested information and test the connection. For details, refer to Working with Data Sources and to the JasperReports Server Administrator Guide. |
| 17. | When the test succeeds, click Next. |
If you use a commercial edition of the server, the Locate Access Grant Definition page appears, prompting you to set the properties for the resource.
| Locate Access Grant Definition Page |
| |
| 18. | Click one of the following: |
| • | Do not link an Access Grant if you don’t need to apply data security. |
Then click Next and skip to step step 22.
| • | Upload a Local File to select a file from your local computer. |
Then click Browse, navigate to select the file you want, and click Select.
| • | Select a resource from the Repository to select an existing schema. |
Then click Browse, navigate to select the schema, and click Select.
In our case, we don’t need to secure the data in the view, so won’t specify an access grant schema. The next steps show you how to add a file if it’s needed.
| 19. | Click Next. |
The Access Grant Resource page appears.
| Access Grant Resource Page |
| |
| 20. | If you chose to upload a new file from your computer, the fields are editable. Enter the requested information. For details, refer to Uploading an Access Grant Schema. If you chose a file from the repository, the fields aren’t editable. |
| 21. | Click Next. |
The Define the Query page appears and prompts you for an MDX query string.
| Define the Query Page |
| |
| 22. | Enter an MDX query. For example, type: |
select {[Measures].[unit Sales], [Measures].[store Cost], [Measures].[store Sales]} on columns, {([Promotion Media].[All Media], [Product].[All Products])} ON rows from Sales where ([Time].[2012].[Q4].[12])
To learn more about writing MDX queries, refer to the reference material listed in External Information Resources.
| 23. | Click Submit. |
If the view passes validation, it is added to the repository. If you receive an error, it is likely that the problem is a typo in your query. Carefully review the query to ensure that it is valid.
| 24. | When you have a valid OLAP view, clicking Submit adds it to the repository. |
If the view passes validation, it is added to the repository.
Recommended Comments
There are no comments to display.