After configuring the Analytic Server computer to use SQL Interface or
Hybrid Analysis, you must complete some additional tasks before beginning
to use them. The following topics contain a summary of the required tasks.
Before using Hybrid Analysis:
- In the essbase.cfg file, set HAENABLE TRUE. See
the HAENABLE topic in the Analytic Services Technical Reference for syntax and usage guidelines.
- In Spreadsheet Add-in options, on the Zoom tab,
select the option to enable Hybrid Analysis.
- Ensure that the name of the ODBC Data Sources used to connect to both
the OLAP Catalog and the data source database are exactly the same on the
Analytic Server as those used on the Integration Server to build the outline.
The user names and passwords for connecting to those databases should also
be identical.
- Build the Analytic Services database with a DB2 OLAP Integration Server metaoutline that invokes
Hybrid Analysis. See the DB2 OLAP Integration Server documentation for detailed information on how
to complete these tasks.
Before using SQL Interface to load SQL, relational, or flat-file data,
you must perform additional preparation tasks. See the Analytic Services SQL Interface Guide for detailed information and instructions for
each of these tasks.
- Configure the ODBC driver and point it to its data source.
- Check that you can connect to the data source by using the Data Prep Editor
in Administration Services Console to open the SQL source file.
- Create a data load rules file to tell SQL Interface how to interpret and
load the SQL data into the Analytic Services database.