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 ?
- 2 Answers
- 9690 Views
- Mphasis, I also Faced
- E-Mail Answers
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
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
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?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Is there any other repository domains rather than universe, security, document?
Explain what would you consider as your biggest achievement and why?
What is the difference in creating filters in designer and business objects?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the functional & architectural differences between business objects and web intelligence reports?
What is difference between custom hierarchy and report based hierarchy?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is aggregate table and aggregate fact table ... Any examples of both?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
