Viewing: Jaspersoft OLAP Administration > Creating an XML/A Source

XML/A Configuration

Jaspersoft OLAP can run as a XML/A server, allowing OLAP queries to be run from remote clients and query results returned to those clients over the XML/A web services protocol. The OLAP data for XML/A comes from Mondrian Connections.

Jaspersoft OLAP XML/A connections, which were defined above, provide a client view to XML/A servers, including Jaspersoft OLAP. You may want to run separate Jaspersoft OLAP servers, splitting the Jaspersoft OLAP XML/A clients from the XML/A servers. This client/server configuration allows load balancing, 24/7 availability and fail over in Jaspersoft OLAP environments. Other clients that can connect to Jaspersoft OLAP running as a XML/A server include Excel Pivot Tables with the Jaspersoft ODBO Driver.

In order to allow Jaspersoft OLAP to run as a XML/A server, XML/A Sources need to be defined in the repository. The list of XML/A sources a given client can connect to can be controlled by repository permissions, as XML/A clients must authenticate via user name and password, and their access to the repository will be limited by permissions. In Jaspersoft OLAP Professional and Enterprise, OLAP data level security can be used to filter OLAP query results based on the user making the XML/A requests.

Creating an XML/A Source

Elements of an XML/A Source

An XML/A source defines a single OLAP data source that can be used by an XML/A client. The Catalog name uniquely defines the data source for the XML/A client. The XML/A source defines a particular Mondrian connection in the repository which will service OLAP query requests.

To add an XML/A source:

1.        Click View> Repository.
2. In the Folder panel, navigate to Organization > Analysis Components > xml/a.
3. Right-click xmla and select Add Resource > Mondrian XML/A Source from the context menu.

The Set Mondrian XMLA Source Properties page appears, prompting you to enter basic information.

.

Set Mondrian XMLA Source Properties Window
4. Enter XML/A source information. For example:

Name

SugarCrmMondrianXmlaSource

Resource ID

Sugar CRM Mondrian XML/A Source

Description

Sugar CRM Mondrian XML/A Source

Catalog

The name of the database that contains the data to analyze.

Mondrian Connection Reference

The path and name of the connection this XML/A source references.
5. Click Submit to save the XML/A source.

After you create the XML/A connection source, you can create an OLAP view using it. For more information, see Working with OLAP Views.

Editing an XML/A Source

You can change an XML/A source name and connection properties.

To edit an XML/A source:

1.        In the Search field, enter the name (or partial name) of the schema you want to edit, and click the Search icon.

For example, enter sugar.

The Repository appears, displaying the repository objects that match the text you enter.

2. Select an XML/A source, then right click on the source and select Edit.

The Set Data Source Type and Properties window appears.

 

Set Data Source Type and Properties Window
3. Click each active field you want to change and enter the new data.
4. Click Submit.

The updated source appears in the Repository.