top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are aggregations and if we have to do it on physical layer side then how u do it?

+1 vote
333 views
What are aggregations and if we have to do it on physical layer side then how u do it?
posted Aug 11, 2016 by Abhimanyu Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You can use the Aggregate Persistence Wizard to create the SQL file that will be used to create aggregate tables and map them into the metadata.
Do not use aggregate persistence against tables with active Virtual Private Database (VPD) security filters. There is a possibility that the aggregate information might be persisted without the VPD filter, posing a security risk.

The Aggregate Persistence Wizard is a nifty utility for creating, modelling and populating aggregate tables available in OBIEE 10g and 11g. This utility is especially useful to quickly build a single aggregation layer upon federated heterogeneous physical sources. OBIEE will create, model and populate aggregate dimensions and facts based upon the intelligence you have built into the RPD. This avoids re-writing the same logic into your ETL

answer Aug 22, 2016 by Manikandan J
...