which is the best way to resolve loop context r alias why?
Answers were Sorted based on User's Feedback
Answer / narsi
most of the cases are using context can be use to resolve
the loops. why because more number of complexity loops and
also schema contains 2 or more fact tables in ur universe design
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / tejaswi
The best way is whichever way solves your problem I use both depending on the situation. If you have a specific problem, try giving us a simple example.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vams_gk
in a schema we have only one look loop u can create
loop.but when we have multiple look up u can create
contexts.
Is This Answer Correct ? | 1 Yes | 4 No |
What is the difference between absolute and relative div positioning?
What is the merge dimension?
how did u give developed universe to ur client?
What is global filters and local filters
Can you please send me the migration related issues .
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Report have 10000 records,how to restrict the end user to 1000 Records?
WHAT IS SAP BO AND BO?
What is meant by data federator and what is the use of it?
How can you check the universe?
how to limit number of rows in a report in business objects using webi?
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest