To change the naming, connection, or MDX query in an OLAP view:
| 1. | In the Search field in the repository, enter the name (or partial name) of the OLAP view you want to edit, and click the Search icon. |
For example, enter food.
The repository displays the objects that match the text you enter.
| 2. | Right-click a view and click Edit. In this example, we’re editing the Foodmart Sample Analysis View. |
The Name the View page appears with the fields populated.
Name the View Page |
![ja-add-view-nametheviewedit_378x269.png.af37793e571346ecd25b9802003ce270.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 3. | Make your changes to the fields as necessary and click Next. |
The page that appears depends on the type of client connection defined in the view. For example, if the view specifies a Mondrian connection, the Locate a Mondrian Connection Source page appears.
Locate Mondrian Client Connection Source Page |
![ja-add-view-locatemondrianolapclientconnsource_488x178.png.f6ee3028c41d41d9f265919feefa9955.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
The Define a Query page appears with the query language set to MDX.
![ja-edit-view-MDX-query_498x250.png.6e4c8f917d5c79bbc6b55dcb87244e4d.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
Define the Query Page |
| 6. | Change the query or enter a new one, if necessary. |
![note-icon-ns_28x28.png.72b0f18046adf5180fd92ad6141f0a9d.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) | You can also edit a view’s MDX query by modifying the navigation table and saving the view. To learn more about writing MDX queries, refer to the reference material listed in External Information Resources. |
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.
| 8. | When you have a valid OLAP view, clicking Submit adds it to the repository. |
Recommended Comments
There are no comments to display.