Intro
Online analytical processing, or OLAP, is an approach to answer multi-dimensional analytical queries swiftly in computing. Use this connector to get your OLAP data into Domo. OLAP (online analytical processing) is a computer processing technology that enables a user to easily and selectively extract and view data from different perspectives. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company’s beach ball products sold in Florida in July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Florida in the same period. OLAP data is stored in a multidimensional database to facilitate this analysis. Whereas a relational relational database can be thought of as two-dimensional, a multidimensional database considers each data attribute (such as product, geographic sales region, and period) as a separate “dimension”. OLAP connector can connect to such multidimensional databases/cubes and fetch the results using MDX query. You can connect to your OLAP account in the Data Center. This topic discusses the fields and menus specific to the OLAP connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.Prerequisites
To connect to your OLAP account and create a DataSet, you need the following: If the connection type is Xmla, you need the XMLA path, username, and password. If the connection type is Mondrian, you need the catalog name and JDBC driver.Connecting to Your OLAP Account
This section enumerates the options in the Credentials and Details panes on the OLAP Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your OLAP account. The following table describes what is needed for each field:Field | Description |
|---|---|
| Connection Type | Select the connection type. |
| XMLA Path | Enter the XMLA Path. This is required if the connection type is Xmla. |
| Catalog Name | Enter the Catalog name. This is required if the connection type is Mondrian. |
| Username | Enter the user name. This is required if connection type is Xmla. |
| Password | Enter the password. This is required if connection type is Xmla. |
| JDBC Driver | Enter the JDBC Driver. This is required if connection type is Mondrian. |
Details Pane
| Menu | Description |
| MDX Query | Enter the MDX Query. |