Explanation/Reference:
The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.
OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository.

B: Example:
1. Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level)

b
2. Do the similiar setting for dimension table
Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table
Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.

Explanation
Explanation/Reference:
Screenshot below.

Explanation/Reference:
Denormalized data in the transactional system could be divided into different tables to increase performance.

Explanation/Reference:
Open up the Administration tool, go to Manage then variables.
See screenshot below.

Then follow this picture to create a new Initialization Block.

Name your Initialization block init_block_test.