Strategy ONE

Configure the Essbase Client and the MDX Cube Provider

After you complete the installations described in Install the MDX Cube Provider and the Essbase Client, configure them as follows:

  1. After installing the Essbase client and Essbase C API, you must create various environment variables. Strategy provides scripts to create the required environment variables.

    Using a command line interface, navigate to the Strategy Common Files folder and execute one of the following scripts:

    • For 64-bit Essbase clients:

      EssbaseConnector_SetEnv_64_64.cmd

    • For 32-bit Essbase clients:

      EssbaseConnector_SetEnv_32_32.cmd

  2. In the installation location for the Strategy MDX Cube Provider, you must modify the Datasources.xml file. We recommend making a backup copy before modifying this .xml file.

    1. In the Datasources.xml file, locate the <AuthenticationMode></AuthenticationMode> section.

      Within this section, type the value EssbaseBasic.

    2. In the Datasources.xml file, locate the <ProgramID></ProgramID> section.

      Within this section, type the value ESSBASE.

      The Datasources.xml file includes an example definition for the <DataSources></DataSources> section with default values for an Essbase connection. You can use this section as a template for the <DataSources> definition of your Oracle Essbase connection.

Upon completing the configurations, see Verify the MDX Cube Provider and Oracle Essbase Configurations for next steps.