An OLAP view can retrieve data from an XML/A connection. An XML/A connection is a connection to a remote Mondrian client connection. For more information on XML/A connections, refer to Working with XML/A Connections and Working with XML/A Sources.
To create an OLAP view with an XML/A connection:
| 1. | Click View > Repository. |
The repository appears.
| 2. | In the Folder panel, navigate to Organization > Organization > Analysis Components > Analysis Views. |
| 3. | Right-click the Analysis Views folder and select Add Resource > OLAP View from the context menu. |
The Name the View page appears and prompts you to enter the basic details about the new view.
In the Query String field, enter the MDX query. Name the View Page |
|
| 4. | Enter a name and a description of the view and click Next. |
The Locate Mondrian Connection page appears.
| 5. | In the Connection Type drop-down, select XML/A Connection. |
| • | Define a XML/A Client Connection in the next step to add a new connection. |
| • | Select a XML/A Client Connection from the Repository to select a data source from the repository. |
Click Browse, navigate to the location where you want to add the file, and click Select. Click Next and skip to step 9.
| 7. | If you chose to create a new client connection, the Set Connection Type and Properties page appears and prompts you to define the connection, Enter the requested information. For details, refer to Working with XML/A Connections. |
Set Connection Type and Properties - XML/A Page |
|
The Define the Query page appears and prompts you for a query string.
Define the Query Page |
|
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.
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.
| 11. | When you have ca 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.