Connecting to Essbase (CubeQuery only)

This section shows how to create a new Interactive Reporting connection file. When you query against an Essbase cube, by default the Interactive Reporting document is created in the CubeQuery section. To use these instructions you must have access to an Essbase 7.x or 9.x server used as a data source. In addition Interactive Reporting requires an Essbase 9.3 or greater Runtime client installation.

Note:

Be sure the option to use the pre 9.3.1 OLAPQuery section has been disabled. Select Tools, then Options, then Program Options , then OLAP, and disable the Use Old OLAP Query section option.

  To connect to Analytic Server:

  1. Select Tools, then Connection, and then Create.

    The first Database Connection Wizard is displayed.

  2. From the What connection software do you want to use? drop-down, select Essbase.

  3. From the What type of database do you want to connect to? drop-down, select Essbase.

  4. Click Next.

    The second Database Connection Wizard is displayed.

  5. Enter a user name in the User Name field.

  6. Enter a password in the Password field.

  7. Enter the host (server) name in the Host field.

  8. Click Next.

    The third Database Connection Wizard is displayed.

  9. From the Application/Database drop-down, select a cube and click Next.

    The fourth Database Connection Wizard is displayed.

  10. From the Dimension Name drop-down, select the measure dimension and click Next.

    Measures are numeric values in a database cube available for analysis. Measures could be margin, cost of goods sold, unit sales, budget amount, and so on.

    The fifth Database Connection Wizard is displayed.

  11. Click Finish.

  12. When you are prompted to save the OCE (Interactive Reporting database connection file), click yes.

    The Save Open Catalog dialog is displayed.

  13. Enter a file name and click OK.

    A new Query section is created in a blank Interactive Reporting document file.