1. what are the differences between prompt at universe level
and prompt at report level ?
2. what are the connection types in BOXI ?
3. how do we give the security in universe level ? and
report level ? and objects level ?
4. what will happen if we check the 'MULTIPLE SQL STATEMENTS
FOR EACH MEASURE' option in Universe SQL parameters ?
Answers were Sorted based on User's Feedback
Answer / shamanth
1. what are the differences between prompt at universe level
and prompt at report level ?
A)Prompts at UNV level are called Predefined Prompts which
can be used across all the reports where ever required.
Report prompt will work on in that report,hence local to
that report.
2. what are the connection types in BOXI ?
A)personal .LSI
Shared .SSI
Secured BOmain.key
3. how do we give the security in universe level ? and
report level ? and objects level ?
A)UNV -> Tools -> Manage Security
Report level & Object level security will be given by Admins
4. what will happen if we check the 'MULTIPLE SQL STATEMENTS
FOR EACH MEASURE' option in Universe SQL parameters
A)We will check this option for Chasm and Fan traps,this
option will generate multiple SQL stmts for each measure
included in a Query........let me know if any modifications
for above ans..
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / bhaskar
Need more information about following
personal.LSI,
shared.SSI,
secured.KEY FILES
| Is This Answer Correct ? | 1 Yes | 0 No |
in xir2 how to send reports to end user
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain what task is 98% of the required work of a business analyst?
Can anybody tell me the difference b/w canned and adhoc reporting?.
What are templates? Explain what you have created?
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
When we are going for Shortcut join and why.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Can we take report on Excel in Business Objects?
6 Answers Business Intelligence Analytics, Oracle,
how will you move the universe/report from development to production?
Which versions are used in the bo dashboard work?