Archive for 'ALL' Category

OBIEE Certification

By Dhwani Shah - Last updated: Tuesday, November 30, 2010

Since winter of 2008 Oracle Certification team was considering coming up with OBIEE certification.They took survey as well on this aspect. Click here to go through Oracle Blog to know the details where they were considering to put an exam for OBIEE. Please see below details about the exam needed for OBIEE certification. It surely [...]

OBIEE Best Practices / Design Principles for 3 layers of Repository

By Dhwani Shah - Last updated: Saturday, November 6, 2010

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

By Dhwani Shah - Last updated: Sunday, October 31, 2010

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

By Dhwani Shah - Last updated: Saturday, October 23, 2010

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

By Dhwani Shah - Last updated: Saturday, October 16, 2010

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 [...]

Utilities provided in OBIEE ( OBIEE Administration tool)

By Dhwani Shah - Last updated: Saturday, February 20, 2010

Today, we are going to discuss something about the “Utilities” feature in Admin tool. This Utility feature is very helpful  in the development, maintenance and administration of repository. Accessing Wizards and Utilities Start > Programs > Oracle BI > Administration In Administration tool, go to  tool > Utilities Click on Utilities , Now the next [...]

Performance Tuning in OBIEE

By Dhwani Shah - Last updated: Friday, February 19, 2010

Performance Tuning Today we are going to discuss about various options for improving performance of reports in OBIEE. There are lots of options available in OBIEE to improve performance of reports. Today will discuss about these… 1)   Aggregate tables 2)  Cache  ( Cache Management) 3) Turning off logging 4) Constructing result using where clause 5) [...]