How do I disable cache for only 2 particular
tables?
In the physical layer, right click on the table there we will have
the option which says cacheable
Is it mandatory to have hierarchies defined in your
repository? If Yes, where does it help? If No, what happens in the reports?
In OBIEE 10g,
it is not mandatory. These are used for drill down and level based measures
In OBIEE 11g it
is mandatory, else you get some warnings and errors.
How do you
create outer joins in physical layer?
We cannot
create
Minimum
criteria to pass consistency checking for a given repository -> One Dimension table and
One Fact table.
How do we
upload new file into BI server in 10g and 11g?
In 10g using
NQSConfig.ini
In 11g using EM
(EM manages NQSConfig.ini)
How to bypass
server authentication?
You can bypass
the authentication in NQSConfig.ini and instance config.xml, BYPASS SERVER AUTHENTICATION=YES
How we can do different types of narrative Reports in OBIEE?
How we can do different types of narrative Reports in OBIEE?
By clicking
modify request and Narrative View and by giving @1 for the first column result
and @2 for the 2nd column and so on and we can also give a heading for No
Results by clicking the Narrative view.
What is write-back in obiee ?
We can give a column as updatable and then view
the reports,this option is called write back option.
How will you execute Direct SQL in OBIEE?
By clicking
Direct Database Request below the subject area in we can execute Direct SQL in
OBIEE.
How we can create report from two subject areas?
UNION
Report.
From
the Criteria Pane of the Report Created from First Subject Area
come to the bottom of the page and click combine request. By this we can create report from two subject areas.
come to the bottom of the page and click combine request. By this we can create report from two subject areas.
