Archive for 'OBIEE Repository' Category
Usage Tracking in OBIEE
Down load UsageTracking Web Catalog Down load UsageTracking rpd UsageTracking Tables Creation Scripts Introduction Oracle BI server supports collection of usage statistics which can use in a variety of ways such as who is running what and when database optimization, aggregation strategies, figuring out most used reports, billing departments as per their usage etc. Goal [...]
Implicit Fact Column in OBIEE
Often time you will come across scenario where in presentation catalog you have 2 or more fact tables and couple of dimensions. And not all the fact tables are joined with all the dimensions. And when you just query the data out of dimension which is not joined to a fact table. It will give [...]
OBIEE interview questions
Below are list of questions you may face during interview. This is part of overall effort to put the interview questions for OBIEE, DAC, Informatica , Oracle Pl\sql and DW Concepts Thing to remember, it also depends on weather interview you are facing is for consulting or full time ? in requirement OBIEE is good [...]
OBIEE Best Practices / Design Principles for 3 layers of Repository
1) Physical Layer Best Practices 2) Business Model & Mapping Layer Best Practices ( BMM layer Best Practices) 3) Presentation Layer Best Practices
OBIEE Presentation Layer Design Principles/Best Practices
There are certain design principles or best practices oracle suggest in designing the OBIEE repository. If you open any standard/sample repository provided by oracle you will understand what exactly I am talking about Today we will discuss the design principles for Presentation Layer. Principle 1.Subject Areas Do not include all presentation layer objects in a [...]
OBIEE BMM Layer Design Principles/Best Practices
OBIEE BMM Layer Design Principles / Best Practices There are certain design principles or best practices oracle suggest in designing the OBIEE repository. If you open any standard/sample repository provided by oracle you will understand what exactly I am talking about Today we will discuss the design principles for BMM Layer. Principle 1. Use Multi [...]
OBIEE Physical Layer Design Principles/Best Practices
There are certain design principles or best practices oracle suggest in designing the OBIEE repository. If you open any standard/sample repository provided by oracle you will understand what exactly I am talking about Today we will discuss the design principles for physical layers Principle 1 :Import only needed tables in physical layer and do not [...]