When we can use multiple sql statement for each measure?
and multiple sql statement for each context?
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 much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain difference between zabo and webi?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain how many universes can be created in a project?
Explain about a time when you discovered a more efficient way to do a work task?
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...
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...
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are the join problems comes appart from loop,chasm & fan Traps
Can more than 1 metric be applied on an analytic in business objects?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?