Creating a Mondrian Connection
To create a Mondrian connection:
| 1. | Click View > Repository. |
The repository page appears.
| 2. | In the Folders panel, navigate to Organization > Organization > Analysis Components > Analysis Connections. |
| 3. | Right-click the folder and select Add Resource > OLAP Client Connection. |
The Set Connection Type and Properties page appears and prompts you to define a connection.
Set Connection Type and Properties Page |
|
By default, the server prompts you to create a Mondrian connection, If you want to create an XML/A connection, refer to Creating an XML/A Connection.
| 4. | Enter a name and description for the new connection. The Resource ID field is auto-generated when you type in the Name field. After it is saved, it can’t be changed. |
| 5. | To change the location of the connection, click Browse, navigate to a folder, and click Select. |
The Locate OLAP Schema page appears and prompts you to upload an OLAP schema or select one from the repository.
Locate OLAP Schema Page |
|
| • | Upload a Local File to select a file from your local computer. |
Then click Choose File, navigate to select the file, and click Select.
| • | Select a resource from the Repository to select an existing schema. |
Then click Browse, navigate to select the file, and click Select.
The OLAP Schema Resource page appears.
OLAP Schema Resource Page |
|
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 OLAP Schema. If you chose a file from the repository, the fields aren’t editable.
The Locate Data Source page appears and prompts you to create or select a data source.
Locate Data Source Page |
|
| • | 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 select the file, and click Select.
The Set Data Source Type and Properties page appears.
Set Data Source Type and Properties Page |
|
If you chose to define a new data source, the fields are editable. Enter the requested information. For details, refer to Working with Data Sources. If you chose a data source from the repository, the fields aren’t editable.
The Locate Access Grant Definition page appears and prompts you to set the properties for the resource.
Locate Access Grant Definition Page |
|
| 13. | Click one of the following: |
| • | Do not link an Access Grant if you don’t need to apply data security. |
Then skip to step step 16.
| • | 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.
If you chose to secure the view, the Access Grant Resource page appears.
Access Grant Resource Page |
|
| 15. | If you chose to upload a new AGXML file, the fields are editable. Enter the requested information. For details, refer to Uploading an Access Grant Schema. If you chose an access grant file from the repository, the fields aren’t editable. |
The Mondrian connection is added to the repository. Views can now reference this connection to expose data to your users. For information on creating OLAP views, refer to Administering OLAP Views. For information of creating Ad Hoc views, refer to TIBCO JasperReports Server User Guide.
Recommended Comments
There are no comments to display.