You can change the connection name, schema, data source, and access grant definition in a Mondrian connection.
To edit a Mondrian connection:
| 1. | In the Search field, enter the name (or partial name) of the Mondrian connection you want to edit, and click the Search icon. For example, enter foodmart. |
The repository appears and displays objects that match the text you entered.
| 2. | Right-click the Mondrian connection you want to edit and click Edit. |
The Set Connection Type and Properties page appears with the fields populated.
Set Connection Type and Properties Page |
|
| 3. | Change values as necessary and click Next. |
The Locate OLAP Schema page appears.
Locate OLAP Schema Page |
|
You can either accept the existing file or replace it. If you replace the file, you can either upload a new file or select one from the repository.
| 4. | To accept the existing file, click Next. |
| 5. | To replace the file, either: |
| • | Click Upload a Local File and click Browse to upload a new schema from your local computer. |
| • | Click Select a resource from the Repository, click Browse, and navigate the repository to the schema you want to use. Then click Select. |
The OLAP Schema Resource page appears.
OLAP Schema Resource |
|
| 7. | If you chose to upload a new file, enter a name and description for it. |
If you accepted the existing file or selected one from the repository, the fields aren’t editable.
The Locate Data Source page appears.
Locate the Data Source |
|
You can either accept the existing data source or replace it. If you replace it, you can either define a new data source or select one from the repository.
| 9. | To accept the existing data source, click Next. |
| 10. | To replace the data source, either: |
| • | Click Define a Data Source in the next step. |
| • | Click Select a Data Source from the Repository, click Browse, and navigate the repository to locate the data source you want to use. Then click Select. |
If you accepted the existing data source, or if you selected a data source from the repository, that connection is used. Clicking Next displays the Locate Access Grant page.
If you chose to define a new data source, the Set Data Source Type and Properties page appears.
Set Data Source Type and Properties Page |
|
| 12. | Enter the requested information, For details on defining data sources, refer to Working with Data Sources and to the JasperReports Server Administrator Guide. |
| Test the new data source to ensure it works properly. |
The Locate Access Grant Definition page appears.
Locate Access Grant Definition Page |
|
| 14. | Click one of the following options: |
| • | Do not link an Access Grant. Click Next and skip to step 17. |
| • | Upload a Local File. Click Browse to select a different local file. |
| • | Select a resource from the Repository. Click Browse to select a different file in the repository. |
If you chose to secure the data, the Access Grant Resource page appears.
Access Grant Resource Page |
|
| 16. | If you upload a new AGXML file, enter the requested information. For details, refer to Uploading an Access Grant Schema. If you selected a resource from the repository, the fields aren’t editable. |
The updated connection appears in the repository.
Recommended Comments
There are no comments to display.