All Questions

The Questions in this blog are classified as Standard and Tough. The answers for all the questions are given in the subsequent sections.

Standard

1. What are the different types of Schema in Dimensional Modeling?

2. Why do we create an alias table in OBIEE?

3. What are the different types of Variables that can be associated to an Initialisation Block?

4. What is the difference between a Dimension Table and Fact Table?

5. What are the different Types of Fact Tables?

6. How do We create Sub Folders in the Presentation Layer?

7. Can We create a Subject Area from two different Business models?

8. How do we rename a presentation table so that its alias name is retained?

9. Why do we create Complex joins in BMM Layer?

10. Where do we specify the Outer Join between two tables in OBIEE?

11. How do we see all the OBIEE Server Cache entries?

12. What are Repository Variables?

13. What is the difference between a Repository Variable and Session Variable?

15. What is the difference between System Session Variable and Non System Session Variable?

16. What are the different Types of Authentication in OBIEE?

17. Explain the different Types of Security Levels in OBIEE?

18. What is the difference between WHERE Clause and Fragmentation Content of a Logical Table Source?

19. How do we create a Presentation column that its name should display Western Region for West Users and Region for remaining users?

20. How do you configure a Subject Area that its reports never gets Cached?

21. What is a Role Playing Dimension?

22. What is a Time Dimension?

23. What is a Junk Dimension or Garbage Dimension?

24. What is a Multi Valued Dimension?

25. What is a Factless Fact Table?

26. What is a Transaction Fact table?

27. What is a Periodic Fact Table?

28. What is Event Fact Tables or Accumlating Snap shot Fact table?

29. Why do We Create Dimensional Hierarchies?

30. What are level based measures?

31. Explain the significance of Number of Elements at this level in Dimensional Hierarchy?

32. How do we configure a report with all its Sub Totals displayed at the bottom?

33. When do we use Complex Joins in Physical layer?

34. How do we create level based measures in Answers?

35. What is the configuration that needs to be done in rpd to generate an Inline view in the SQL?

36. What is the Use of Retaining the Alias Name in the Presentation Layer?

37. Explain the significance of Implicit Fact Column in the Presentation Catalog?

38. What modification should be done in the report that the query hits the database, by passing the OBIEE Server cache?

39. A Subject Area is Configured against OLTP, how do we clear the cache pertaining to this Subject Area every 12 hours?

40. How do we purge All Cache entries from UI?

41. How do we create a report with metrics of Multiple Granularity?

42. How do we Create two Sub Folders under different Folders with the same name in the Presentation Layer?

43. Table W_FACT_T_F has two columns ROW_WID,METRIC. Write a Single Update Statement to update metric=500 for row_wid less than 10000 and metric=900 otherwise.

44. How do we create sub reports in BI Publisher?

45. How do we create sub totals and Grand Total in BI Publisher Report?

Tough

1. How do we do cross conditional formating in a pivot table on a dimension column based on measures?

2. How do we do cross conditional formating in a pivot table on a fact column based on dimensions?

3. How do we create two bar charts in a report with their corresponding bars arranged in the descending order of the metrics?

4. How do we combine two reports from different Subject areas by Joining the common attributes?

5. How do we use COMPLEX FROM CLAUSE in Advanced SQL Clauses in OBIEE?

6. What are Event Polling tables? How do we Implement them?