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 |
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
can u create report to connect oracle and sqlserver at a time?
What are Alerter, Filters, Breaks and Conditions?
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
what are cascading prompts explain with steps
What is the size of data base?
in sap bi we have wad, then why we go for sap bo
what r the types of joins universe supports
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What are the different types of Filters available in BUSINESS OBJECTS?
WHAT DOES SQL TAB CONTAIN?