Archive for 'OBIEE Administration' 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 Administrator Task
I often get questions via Contact US page on as below. And decided to write a small post to address this what are the duties of OBIEE Admin ? I want to know the day to day activities of OBIEE Admin, Can you please send me if is there any material regarding admin tasks of [...]
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 Certification
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 [...]
Utilities provided in OBIEE ( OBIEE Administration tool)
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
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) [...]