1.What is the purpose of Saved Filters in OBI EE reports?
2.What is the scope of Page level and Dashboard level prompts ?
3. Display top 5 highest salaried employees in OBI EE Report ?
4. When you create a request what is the background process to get the results in obiee report ?
5. What is cross conditional formatting in obiee ?
6. How to display last 15 months data in OBI EE reports?
7. What is purpose of saved section in the OBI EE Dashboard?
8. Give me some examples of OBI EE Analytical functions?
9. How to pass parameters in BI Publisher report?
10. Scenario: In Pivot table view we put one column in excluded, is BI Server place an entry in query log for the excluded column?
11. Guided Navigation in OBI EE?
12. Level based Measures?
13. Types of Hierarchies in OBI EE?
14. How to implement Data Level and Object level security in OBI EE in LDAP Authentication model?
15. My Report has a column "COLOR" how to display corresponding color instead of displaying value?
16. What is the purpose of protected filter in OBI EE?
17. What are the Best Practices implemented in RPD Development of your current project?
18. What is the purpose of Column Selector view?
19. How you create presentation variable?
20. What are the different hierarchies in RPD?
21. What is implicit fact column?
22. What is the use of DAC other than monitoring and scheduling the Informatica Workflows?
23. How the new and updated data will store in warehouse in incremental load?
24. Explain about Lookup transformation?
25. Use of Mapplets?
26. What is Materialized View?
27. Explain Implicit cursors and Explicit Cursors?
28. Explain Noraml Forms ?
29. Explain the SCD type 2 process?
30. What are the differences between connected and unconnected lookup?
31. What are all the major differences between Filter and Router Transformation?
32. Can we implement Incremental Load with out using Update Strategy transformation?
33. What is the purpose and how to create a parameter file in Informatica?
34. What is the purpose of Stored Procedure Transformation in Informatica?
35. What is the use of source qualifier transformation?
36. Can we use Complex join in Physical Layer?
37. Can we use Physical join in BMM Layer?
38. How to get my Rpd password if i forgot?
39. How to develop a report using 2 different data sources in my Physical layer?
40. What are the performance increasing steps if your OBIEE report if it is taking much time to get the results[its Dynamic Report, using dashboard prompts the values changes dynamically]?
41. What is BI Publisher Report Bursting ?
42. How to place the map in OBIEE Report based on that the user can select the regions to get the data on report?
43. How to create a report using 2 different subject areas in OBIEE 10g version?
44. What are the features of OBIEE 11g version?
45. Scenario: On my Dashboard page i have a prompt, it contains drop down values like Report1, Report2, Report 3 and Report4, once i select Report1 the Report1 should display on my Dashboard page , based on the user selection.
46. In which scenarios we hide the Columns in OBIEE report?
47. Scenario: On OBIEE report we have a Creditcard number column, as per my Client requirement we need to display last 4 digits on report instead of 10 numbers, how you implement this ?
48. How do you pass parameters to the OBIEE Report?
49. What are the different status of DAC Server?
50. How to implement External Table level authorization in OBIEE ?
51. Write a sql query to get 3rd Highest salaried employee in my EMP table?
52. What are the fact and dimension tables in your Rpd?
53. How many connection pools in your current project Rpd?
54. What are the differences between ODBC and OCI 10g/11g call interface in Connection Pool?
55. What is Time Series Wizard in OBIEE?
56. OBIEE supports how many types of SCD's?
57. What is the diff between OLTP and OLAP?
58. Can user view the data in OLTP database using OBIEE?
59. Can we create a Presentation folder using 2 BMM folders?
60. How to configure OBIEE Ibots?
61.Tell me about these alias and duplicate tables in repository of obiee and how they differ from one another and when we work on these tables?
62. What is the difference between chronological key and Logical key in OBIEE?
63. Can we create Fact to Fact join in OBIEE?
64. How to resolve Circular joins in Physical layer of RPD?
2.What is the scope of Page level and Dashboard level prompts ?
3. Display top 5 highest salaried employees in OBI EE Report ?
4. When you create a request what is the background process to get the results in obiee report ?
5. What is cross conditional formatting in obiee ?
6. How to display last 15 months data in OBI EE reports?
7. What is purpose of saved section in the OBI EE Dashboard?
8. Give me some examples of OBI EE Analytical functions?
9. How to pass parameters in BI Publisher report?
10. Scenario: In Pivot table view we put one column in excluded, is BI Server place an entry in query log for the excluded column?
11. Guided Navigation in OBI EE?
12. Level based Measures?
13. Types of Hierarchies in OBI EE?
14. How to implement Data Level and Object level security in OBI EE in LDAP Authentication model?
15. My Report has a column "COLOR" how to display corresponding color instead of displaying value?
16. What is the purpose of protected filter in OBI EE?
17. What are the Best Practices implemented in RPD Development of your current project?
18. What is the purpose of Column Selector view?
19. How you create presentation variable?
20. What are the different hierarchies in RPD?
21. What is implicit fact column?
22. What is the use of DAC other than monitoring and scheduling the Informatica Workflows?
23. How the new and updated data will store in warehouse in incremental load?
24. Explain about Lookup transformation?
25. Use of Mapplets?
26. What is Materialized View?
27. Explain Implicit cursors and Explicit Cursors?
28. Explain Noraml Forms ?
29. Explain the SCD type 2 process?
30. What are the differences between connected and unconnected lookup?
31. What are all the major differences between Filter and Router Transformation?
32. Can we implement Incremental Load with out using Update Strategy transformation?
33. What is the purpose and how to create a parameter file in Informatica?
34. What is the purpose of Stored Procedure Transformation in Informatica?
35. What is the use of source qualifier transformation?
36. Can we use Complex join in Physical Layer?
37. Can we use Physical join in BMM Layer?
38. How to get my Rpd password if i forgot?
39. How to develop a report using 2 different data sources in my Physical layer?
40. What are the performance increasing steps if your OBIEE report if it is taking much time to get the results[its Dynamic Report, using dashboard prompts the values changes dynamically]?
41. What is BI Publisher Report Bursting ?
42. How to place the map in OBIEE Report based on that the user can select the regions to get the data on report?
43. How to create a report using 2 different subject areas in OBIEE 10g version?
44. What are the features of OBIEE 11g version?
45. Scenario: On my Dashboard page i have a prompt, it contains drop down values like Report1, Report2, Report 3 and Report4, once i select Report1 the Report1 should display on my Dashboard page , based on the user selection.
46. In which scenarios we hide the Columns in OBIEE report?
47. Scenario: On OBIEE report we have a Creditcard number column, as per my Client requirement we need to display last 4 digits on report instead of 10 numbers, how you implement this ?
48. How do you pass parameters to the OBIEE Report?
49. What are the different status of DAC Server?
50. How to implement External Table level authorization in OBIEE ?
51. Write a sql query to get 3rd Highest salaried employee in my EMP table?
52. What are the fact and dimension tables in your Rpd?
53. How many connection pools in your current project Rpd?
54. What are the differences between ODBC and OCI 10g/11g call interface in Connection Pool?
55. What is Time Series Wizard in OBIEE?
56. OBIEE supports how many types of SCD's?
57. What is the diff between OLTP and OLAP?
58. Can user view the data in OLTP database using OBIEE?
59. Can we create a Presentation folder using 2 BMM folders?
60. How to configure OBIEE Ibots?
61.Tell me about these alias and duplicate tables in repository of obiee and how they differ from one another and when we work on these tables?
62. What is the difference between chronological key and Logical key in OBIEE?
63. Can we create Fact to Fact join in OBIEE?
64. How to resolve Circular joins in Physical layer of RPD?
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.