OBIEE 10g and 11g REALTIME INTERVIEW QUESTIONS :
1) What is complex join, and where it is used?
1) What is complex join, and where it is used?
Ans) we join the dimension table and fact table in BMM layer using complex join. In type2 SCD also use complex join in BMM layer.
2) what is main Difference between OBIEE 10g and obiee11g ?
1) In obiee 10g OC4J is called Oracle container for java ,obiee11g its called as Weblogic server.
2 )obiee 10g Security is managed by RPD. obiee 11g the security and users is managed by welogic server.
3) obiee 11g supports all joins and hierarchies ex :we can move from product dimension to time dimension during drilling down.11g Supports ragged hierarchies.
4) Seletions is not available 10g , seletions present in the presentation services in 11g.
5) New Concepts like scorecards and KPI's are is available in obiee11g,
3) Tell me about the LTS ?
4) How can I configure Oracle MapViewer with OBIEE 11g?
Ans) MapViewer is installed and configured as part of the OBIEE 11g installation process. The post-installation configuration required is to configure MapViewer to point to the source that contain your spatial data and provide you with background maps like Oracle Database, Oracle eLocation, Web Map Service provider, Google Maps.
5) How do OBIEE Architecture works? Ans ) five parts of obiee Architecture. 1. Clients 2. Oracle BI Presentation Server 3. Oracle BI Server 4. Application Server 5. Data Source
6)How do we implementing event polling table in obiee?
Ans)In polling event OBIEE Server tables store information about the updates to the underlying database. These tables are used for the management of the cache. An application that loads the data in a data mart can be configured to add rows to a table of querying for events whenever a database table is updated. The Analytics Server queries this table at defined intervals and invalid corresponding to the tables updated entries from the cache
7) What is the main difference between Single LTS and Multiple LTS?
at RPD level LT table in BMM layer has only one Table as the source table then it is Single LTS.
at RPD LT in BMM layer has more than one table as the sources to it then it is called Multiple LTS.
Ex: Usually BMM Layer one Fact table has Multiple LTSs, for which sources will be coming from different Physical tables in physical layer19) Tell me about process of merging of two Repository?
TCS REALTIME INTERVIEW QUESTION 1) How can we create dashboard? 2) How to restrict / grant access rights to various presentation services features in obiee 3) How can you move dashboard report from one dashboard to other? 4) How to apply object level security and data level base security? 5) what is Table / Pivot & Gauge View? 6) what is Narrative, Ticker & Static Teat? 7) How to apply presentation Variables to Reporting level? 8) give me some practical example you implemented guided navigation? 9) What is the scope dimension, how you implement them obiee? 10) What is the process of merging multiple physical tables to single logical table? 11) How can you create Aggregate Tables in RPD? 12) How do we Implement Usage Tracking in obiee11g 13) If you want to aggregate your data ,How you will generate report? 14) What is S C D? How do you implement them? 15) What is about conformed dimensions in obiee11g
2) what is main Difference between OBIEE 10g and obiee11g ?
1) In obiee 10g OC4J is called Oracle container for java ,obiee11g its called as Weblogic server.
2 )obiee 10g Security is managed by RPD. obiee 11g the security and users is managed by welogic server.
3) obiee 11g supports all joins and hierarchies ex :we can move from product dimension to time dimension during drilling down.11g Supports ragged hierarchies.
4) Seletions is not available 10g , seletions present in the presentation services in 11g.
5) New Concepts like scorecards and KPI's are is available in obiee11g,
3) Tell me about the LTS ?
4) How can I configure Oracle MapViewer with OBIEE 11g?
Ans) MapViewer is installed and configured as part of the OBIEE 11g installation process. The post-installation configuration required is to configure MapViewer to point to the source that contain your spatial data and provide you with background maps like Oracle Database, Oracle eLocation, Web Map Service provider, Google Maps.
5) How do OBIEE Architecture works? Ans ) five parts of obiee Architecture. 1. Clients 2. Oracle BI Presentation Server 3. Oracle BI Server 4. Application Server 5. Data Source
6)How do we implementing event polling table in obiee?
Ans)In polling event OBIEE Server tables store information about the updates to the underlying database. These tables are used for the management of the cache. An application that loads the data in a data mart can be configured to add rows to a table of querying for events whenever a database table is updated. The Analytics Server queries this table at defined intervals and invalid corresponding to the tables updated entries from the cache
7) What is the main difference between Single LTS and Multiple LTS?
at RPD level LT table in BMM layer has only one Table as the source table then it is Single LTS.
at RPD LT in BMM layer has more than one table as the sources to it then it is called Multiple LTS.
Ex: Usually BMM Layer one Fact table has Multiple LTSs, for which sources will be coming from different Physical tables in physical layer19) Tell me about process of merging of two Repository?
TCS REALTIME INTERVIEW QUESTION 1) How can we create dashboard? 2) How to restrict / grant access rights to various presentation services features in obiee 3) How can you move dashboard report from one dashboard to other? 4) How to apply object level security and data level base security? 5) what is Table / Pivot & Gauge View? 6) what is Narrative, Ticker & Static Teat? 7) How to apply presentation Variables to Reporting level? 8) give me some practical example you implemented guided navigation? 9) What is the scope dimension, how you implement them obiee? 10) What is the process of merging multiple physical tables to single logical table? 11) How can you create Aggregate Tables in RPD? 12) How do we Implement Usage Tracking in obiee11g 13) If you want to aggregate your data ,How you will generate report? 14) What is S C D? How do you implement them? 15) What is about conformed dimensions in obiee11g
