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 ?
Answer Posted / 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 |
Post New Answer View All Answers
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Can you please send me the migration related issues .
what is xcelsius architecture?
Difference between zabo and webi?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Can more than 1 metric be applied on an analytic in business objects?
How were the reports scheduled and how to resolve unexecuted documents?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How would you format some text using css to be verdana and bold?
Explain is there any default username & pwd for bo designer & supervisor?
Explain in detail about type 2(scd),
What is difference between custom hierarchy and report based hierarchy?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What sort of existing documents should business analysts refer to when starting on a new project?
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)?