When we can use multiple sql statement for each measure?
and multiple sql statement for each context?
- 2 Answers
- 13201 Views
- I also Faced
- E-Mail Answers
Answer Posted / manju
when your universe having traps then we wil select the options
and when you have dimension objects in one or both fact
tables and universe having traps then we using option
multiple sql statements for each context
when you have measure objects in one or both fact
tables and universe having traps in this case we using option
multiple sql statements for each measure
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is thumbnail?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is the difference between user and versatile user?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is the difference between condition & filter?
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...
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...
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain how we drill up week to month?
What Is Snow Flake Schema?
What is the difference between slice and dice and cross tab report?
Explain what are the measure objects?
