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...
No comments:
Post a Comment