• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Using Aggregates

In this set of steps you set up and use aggregate tables to improve query performance. Aggregate tables store pre-computed results, which are measures that have been aggregated (typically summed) over a set of dimensional attributes. Using aggregate tables is a popular technique for speeding up query response times in decision support systems. This eliminates the need for runtime calculations and delivers faster results to users. The calculations are done ahead of time and the results are stored in the tables. Aggregate tables typically have many fewer rows than the non-aggregate tables and, therefore, processing is faster.

To set up and use aggregate tables, perform the following steps:

• Import Metadata
• Create New Logical Table Sources
• Set Aggregate Content
• Test Your Work

Import Metadata
1 . Return to the Administration Tool and open the BISAMPLE repository in offline mode.
1 . In the Physical layer, expand orcl.
2 . Right-click Connection Pool and select Import Metadata to open the Import Wizard.
3 . In the Select Metadata Types screen, select Views and click Next.

2

4 . In the Select Metadata Objects screen, in the data source view, expand BISAMPLE.
5 . In the data source view, select the following for import:
SAMP_REVENUE_FA2
SAMP_TIME_QTR_D

2

6 . Click the Import Selected button to move the objects to the Repository View.
7 . Expand BISAMPLE in the Repository View and confirm that the objects are visible.

2

8 . Click Finish to close the Import Wizard.
9 . Confirm that the objects are visible in the Physical layer of the repository.

2

At TekSlate, we offer resources that help you in learning various IT courses. 
We avail both written material and demo video tutorials. 
To gain in-depth knowledge and be on par with  practical experience, then explore OBIEE 11g Training Online.
TableAlias
SAMP_REVENUE_FA2F2 Revenue Aggregate
SAMP_TIME_QTR_DD1 Time Quarter Grain

2

11 . Right-click F2 Revenue Aggregate and select View Data. F2 Revenue Aggregate stores aggregated fact information for revenue and units at the quarter and product grain.

2

12 . Right-click D1 Time Quarter Grain and select View Data. D1 Time Quarter Grain stores time data at the quarter grain. It stores one record for each quarter beginning with Q4 2006 and ending with Q4 2011.

2

13 . Use the Physical Diagram to create the following physical joins:
“orcl”.””.”BISAMPLE”.”D2 Product”.”PROD_KEY” = “orcl”.””.”BISAMPLE”.”F2 Revenue
Aggregate”.”PROD_KEY”
“orcl”.””.”BISAMPLE”.”D1 Time Quarter Grain”.”QTR_KEY” = “orcl”.””.”BISAMPLE”.”F2
Revenue Aggregate”.”BILL_QTR_KEY”

2

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Using Aggregates
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Using Aggregates"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.