Archive for 'OBIEE Administrator' Category
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 [...]
NQSConfig.INI – Important things to Remember
File Path: < OBIEE Install Directory> / Oracle BI/ Server/ Config / NQSConfig.INI Here I would like to share the importance of this file First of all NQSConfig.INI is the main Configuration file for BI Server. Because it contains lots of parameters. [Note: After changing anything to this file we have to restart Oracle BI [...]
Execute Direct SQL
Uses of ” Execute Direct SQL “( Direct Database Request) We have seen this in Answers page .Under the subject area. Lets know something more about this today… In Answers with the help of this feature Administrator can debug some issues like…. 1) Check physical connectivity to the database . 2) Check report or dashboard [...]