how to restrict up to three levels in hierarchy when u do
drill mode?

Answer Posted / anji babu

by using scope of analysis at edit query level.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many reports have u created ? explain a few.

1840


in sap bi we have wad, then why we go for sap bo

3021


What are the join problems comes appart from loop,chasm & fan Traps

1779


What would you consider as your biggest achievement and why?

786


Explain how to execute the plsql procedure from the report by clicking with mouse?

800


Explain the difference between detect alias and detect context?

802


Explain the difference between union and group?

821


how to create reports on screech?

2254


Explain is there any default username & pwd for bo designer & supervisor?

777


How to generate the report from excel sheet?

825


any difficulitis have you phase while creating bo reports and how did u solve it

3165


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1920


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1786


When to use local filter and when to use global filter?

767


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1950