Connecting to an OLAP database

Last modified by Aurelie Bertrand on 2026/07/02 11:50

DigDash Enterprise allows you to retrieve information from OLAP databases.

To create an OLAP database :

  1. In the Create New Data Model box, click the OLAP button in the Database section.
    OLAP
    ➡ The OLAP Database dialog box is displayed.
  2. Select the desired connection mode and fill in the required fields:

  • Manual connection mode
    The connection will be visible in the data source only.

    1. In the Database URL field :
      • Select the JDBC driver from the drop-down list: Olap4j
      • Enter the address of your database using the syntax required by the driver.
        Example of syntax used :
        jdbc:xmla:Server=<server XML/A>;[Catalog=<CATALOG>]
    2. In the User field, enter the name of the user to be used when connecting to the database.
    3. In the Password field, enter the password to be used when connecting to the database.
    4. Click Connect to obtain the status of the connection (successful connection or failed connection). If the connection fails, change the connection parameters.
       
  • Named connection mode
    The connection will be visible in the Connection Manager and can be used by all data sources.
    1. Click Select: the Database Connection Manager is displayed.
    2. You can :
      • Select an existing connection from the list. Click OK.
      • Create a new connection as described on the Add a named connection.
         
  • Parameterised connection mode
    This mode allows you to use a database connection assigned to the user via a user parameter.
    See the page Parameterized connection to a database page for more details.
  1. In the MDX query field, enter the MDX query manually or using the MDX wizard. See the Writing the MDX query query page for more details.
  2. Click the Preview button to display a preview of the result.
    See the page Preview page page for more details.

Note: 50 rows are displayed by default.
You can change this number by typing the desired value in the Maximum number of rows for preview field .

  1. You can apply data transformations.
    See the page Transform data page for more details.
  2. Once you are happy with the result, click Next to configure the data model.

You can save the query you have entered for future use. To do this

  1. Click on the Favorites button below your MDX query.
  2. Select Add to favorites then enter the name you want to give to this query.