in report level u find from which context u use,why it
appears,what is the reason,how u resolve in report level
Answer Posted / rekha
When a query is ambiguous, BusinessObjects or
WebIntelligence displays a
dialog box that prompts the user to select one of two
contexts. When the user
selects a context, the corresponding tables and joins are
inserted into the SQL
query.
This should be resolved at universe level by selecting
proper options in universe parameters>SQL>Multiple Paths
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the difference between slice and dice and cross tab report?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
How to create Index to the table in the universe designer and how it improves the Query performence
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)?
What is the difference between the public object&schema object?
Explain is there any other repository domains rather than universe, security, document?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What Is Snow Flake Schema?
What is package in BO
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the difference in creating filters in designer and business objects?
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...