It is often handy to be able to save multiple queries on the same data source within a single document, instead of having to create a different document for each query. To support this, DataWarehouse Explorer supports named queries, or views as we call them. Using views, you can quickly switch between totally different perspectives of your data and reproduce often used queries.
Creating a view
If you have a query of your cube data that you would like to be able to reproduce:
| 1. | In the data sources window, click the + icon in the View column (as shown below) |
| 2. | Type the name and optionally a description for the view and click Ok |
Opening a view
To regenerate the query for a view:
| 1. | Click the drop down button in the View column in the data sources window |
| 2. | Either double-click the name of the view you wish to load or single click and press Load. |
Deleting/Renaming a view
To remove a view from the views list:
| 1. | Click the drop down button in the View column in the data sources window |
| 2. | Click the name of the view and press the Delete key to delete the view or the F2 key to rename the view. |