Yellowfin OLAP Cube Connectivity

...

• Yellowfin inherits the hierarchies and data-types from the cube, and these cannot be changed in Yellowfin. 
• Grouped Columns is not supported on Cubes. 

XMLA Data Source

Interface to an XMLA data source is via a HTTP URL. All data access is performed via HTTP requests to the data source. As such, the only connection parameters required are the XMLA URL, and an optional username and password if the data source requires them. 

Depending on the data source, the XMLA interface may be a built-in feature or require external software and configuration – for example, Microsoft Analysis Services requires IIS to be installed and a virtual directory configured to handle XMLA requests.

1. Create a new connection from the Data Sources section of the Administration page. Click on the Create Image Added button and select Data Source.
   Image Added
2. Select Cube as the data source type 
   Image Removed
   
3. Enter the connection URL
You can also provide a username and password, if necessary
Image Removed

4. type in the "Add a Data Source" popup.
   Image Added
5. Fill in all the required fields in the Cube Settings.
   Image Added 
6. Click on “Test Connection” to ensure a successful connection. Then, click Save.
7. Continue 
8. Click on the Test Connection button to attempt to connect to the data source. Once a connection is made, Yellowfin retrieves the list of Data Sources and Catalogs. 
9. You can then select the default Data Source and Catalog for the connection
   Image RemovedContinue creating views for this cube connection.

Examples of Connections

Microsoft Analysis Services

...

NB. Microsoft Analysis Services 2000 is not supported.

Mondrian

Mondrian is an open-source XMLA interface to an underlying RDBMS. We recommend the use of Mondrian only if existing Mondrian infrastructure is available, as Yellowfin can replicate the functionality of Mondrian directly from a relational database itself. 

...

<servlet-mapping>
<servlet-name>MondrianXmlaServlet</servlet-name>
<url-pattern>/xmla</url-pattern>
</servlet-mapping>

The XMLA URL is the address to the MondrianXmlaServlet, for example:

http://<host>:<port>/mondrian/xmla

...

PALO

The Premium Edition of PALO OLAP server supports XMLA connections by installing the optional XMLA provider.

...

Username: admin

Password: admin

...