OBIEE INTERVIEW QUESTIONS SET 1 (by Narendra Reddy)

1.what is physical join and complex join and when wil v use physicl join in bmm layer and when will we use complex join in physical layer?

2.what is connectionpool?(shared logon,requiredfully qualify names)

3.Opaque view

4.Alias table and senario

5.Aggregate tables

6.Bmm hirarchies(prefered drill path,drilldown,drill through,drill across,number of elements,ragged hirarchy,skip hirarchy,level based hierarchy,value based hierarchy,dimension hierchy,estimated levels)

7.Level based measures.in what situation we can use these level based measures?

8.Measures:   physical measure and logical measure

9.what will u happen with group by and without group by in query?

10.what is the use of logical table source??

11.difference b/w single logical source and multiple logical table source?

12.use of fragmentation??

13.how to filter the data in bmm layer??

14.what is the use of content tab??

15.use of time series functions??

16.Diff b/w ago and todate functions?

17.Use of event pooling table?

18.Utilities

19.Query repository

20.difference b/w offline and online mode

21.Can v create single subject area with 2 business models??

22.can v create 2 subject areas with single business model?

23.Cache

24.Bmm full form:business model mapping

25.Implict fact table

26.How to create a Business model  with single table?

27.Variables:repository,session

28.what is data level security with scenario

29.what is row wise initialization and data level security object level security and query limits?

30.External table authentication

31.Types of authentications

32.Types of security

33.What is meant by authentication and authorization?

34.Alias in presentation layer?

35.Difference b/w session variables and dynamic variables?

36.What is diff b/w union,union all, intersect and minus

37.How to create report with 2 subject areas?

38.Delivers

39.What is agent/ibot

40.Advance tab in delivers

41.how to seed cache?

42.Guided navigation

43.Action link

44.How to hide edit dash board

45.How to create dashboard?

46.How to give permissions to dashboard,report and sections?

47.how to navigate one report to another report?

48.How to create a measure in answers/analytics?

49.Presentation varaible?

50.Types of prompts?

51.Diff b/w filter and prompt?

52.how to disable cache for perticular report?

53.How to set log level for perticular report?

54.What is dashboard storage location path and filter location path?

55.How to give security for dashbord,page,section and report?

56.Choronological key(used for unique identification)

57.NQS config

58.Inline view,scord card,kpi,write back,usage tracking

59.Conform dimension

60.Fact less fact,data mart,datawarehouse

61.Star schema,snow flake schema and how to convert start to snowflake schema?

62.Obiee architecture

63.Project architecture?

64.Top down approach and bottom down approach?

65.conformed fact,types of facts

66.diff b/w logical key and choronological key

67.short order column

68.Purging

69.Request variable

70.Repository performance,report performance?

71.Pivot table view selector,view selector and diff b/w coloum selector and view selector

72.how to create a measure in pivot table

73.Direct database request.How many permissions are needed one user to work on Direct Database          Request

74.How to limit a rows

75.Data format tab

76.Conditional request

77.Total number of views,No result view,narrative view,Legend view

78.how to change logo.

Thanks to Narendra Redddy...