OBIEE CATALOG INTERVIEW QUESTIONS

WEB CATALOG

1. What is meant by Web Catalog?
   It is a container (or) folder structure which is useful to store reports, dashboards, KPIs, score cards, user profiles etc...

2. Is there any other names for web catalog?
   yes. web catalog is also known as BI presentation catalog

3. Which server manages the web catalog?
   web catalog is managed by Oracle BI Presentation Server

4. What are the steps we have to follow while creating web catalog?
   In creating web catalog we have below steps

1. Configure EM(Enterprise Manager)
2. Restart oracle BI presentation server
3. Confirm catalog in catalog folder

5. Where can we find the catalog path in EM?

EM →Core application → deployment→ repository→ lock and edit configuration→ under BI Presentation Catalog we can find the whole path of the catalog

6. What is the default location of the catalog?
   <OBIEE_HOME>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

7. When we restart OBIPS from where it can read the catalog, how it works?
   Whenever we started oracle BI presentation server it will read instancecofig.xml file and it picks the catalog name from file and verifies it is available in catalog folder (or) not. If catalog is available with same name then it will load else it will create new one

8. What is the log file for OBIPS and where can we find it?
   The Log File of Oracle BI Presentation server is THE MAXIMUM VERSION OF THE SAWLOG and it is available in below path <OBIEE_HOME>\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

9. Is there any folders contained by catalog, if yes what are they and where can we find it?
   Catalog contains three folders
1. Shared folder or Public folder
2. Users or My folders or personal folders
3. System
   These three folders we can find in below location <OBIEE_HOME>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite\root  

10. What is the purpose or use of shared, my folder, system  folders?
    Shared Folder:
    This folder is useful to share reports or dashboards or KPIs..etc to end users or business users
    we can't save any reports directly in shared folder, first we have to create a new folder under shared folder then save the reports or dashboards

    My Folder: 
    This folder is personal folder .it will be created for each and every user separately with the name of   user when ever first time he signed into analytics If a user save a report in this folder that cannot be  accessed by any other user . These folders are useful to save partially developed reports
   System:
   It is useful to store system level properties.
   This folder is not accessible from analytics page