Archive for 'ALL' Category

Usage Tracking in OBIEE

By Dhwani Shah - Last updated: Friday, December 2, 2011

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

Oracle DAC System Properties

By Dhwani Shah - Last updated: Friday, December 2, 2011

Oracle DAC System Properties Over view.

Oracle DAC repository Import

By Dhwani Shah - Last updated: Thursday, December 1, 2011

Please are the steps to perforem DAC repository Import Read DAC repository Export Steps here Step 1 :Log on to the DAC where you want to Import the repository. Step 2: Keep a backup of existing repository (if needed) and proceed with the DAC Repository Import. Navigate to Tool -> Repository Management -> Import  Step [...]

Oracle DAC repository Export

By Dhwani Shah - Last updated: Thursday, December 1, 2011

Below are the step which are needed to do DAC Repository Export. If you are looking DAC repository Import please read my post on Import   Step 1 :Log on to the DAC: Step 2 : Navigate to Tools -> DAC Repository Management -> Export Step 3 : Select the Export Folder on your desktop, [...]

Implicit Fact Column in OBIEE

By Dhwani Shah - Last updated: Wednesday, November 30, 2011

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

By Dhwani Shah - Last updated: Tuesday, November 29, 2011

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

Oracle Data Warehouse Administration Console (DAC) interview questions

By Dhwani Shah - Last updated: Tuesday, November 29, 2011

In this post I will discuss some interview questions on Data Warehouse Administration Console (DAC) which checks the key concepts about tool. Check back often as I will be adding the answers here as an when I will get some time over the week ends. If you are looking for some DAC an electronic subject [...]