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 |
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.
Use this section to understand the two methods available for preparing multi-table data:
If data is in multiple tables, create a single table or a view of the data in either of the following ways:
See Choosing a Preparation Method for instructions.
See Preparing Data from Multiple Tables for instructions.
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.
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.
Data load preparation requires specific permissions:
If you cannot obtain CREATE privileges, use Application Manager to join tables during the data load. See Preparing Data from Multiple Tables for instructions.
Use this process 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 |