Hyperion(r) SQL Interface Guide Information Map
Show | Previous | Next
Hyperion(r) SQL Interface Guide Information Map
Hide | Previous | Next
Hyperion(r) SQL Interface Guide Information Map
Show | Previous | Next  
Hyperion(r) SQL Interface Guide Information Map
Hide | Previous | Next  



Preparing Multiple-Table Data for Loading

This section tells you how to prepare relational data in multiple tables for loading into Essbase:

If all your data is in one table, skip to Loading SQL Data.

Understanding Multiple-Table Preparation

Use this section to understand the two methods available for preparing multi-table data:

Understanding Two Methods for Multiple-Table Data Preparation

If data is in multiple tables, create a single table or a view of the data in either of the following ways:

The SQL data source file must always be accessible to OLAP Server. Make sure that the SQL data source file resides on the computer where OLAP Server is installed, or on the network.

Choosing a Preparation Method

A SQL database server reads from a single table and maintains a single view more efficiently than it processes a multiple-table SELECT statement. Therefore, creating a single table or view before you use SQL Interface greatly reduces the amount of processing time the SQL server needs.

Understanding Security Requirements

Data load preparation requires specific permissions:

Preparing Data from Multiple Tables

Use this process to prepare data from multiple tables:

  1. Obtain the required privileges:
  2. Use one of these methods to prepare data from multiple tables:

Note: Essbase passes the SELECT statement to SQL Server without verifying the syntax.




Copyright © 2002 Hyperion Solutions Corporation. All rights reserved.
http://www.hyperion.com