When we can use multiple sql statement for each measure?
and multiple sql statement for each context?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / manoj
When your universe is having multiple context or u have
traps then you will select the options.
| Is This Answer Correct ? | 1 Yes | 3 No |
What is the link option in the reporting Environment?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
4.what is aggregate awareness ? how do we use ? where do we use ?
(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.
How can we improve performance?
What is a loop? How can we overcome?
Explain what would you consider as your biggest achievement and why?