U r project in which stage in implementation?
No Answer is Posted For this Question
Be the First to Post Answer
What is drill across ? can anybody explain me in detail?
Did you face any problems while creating reports? Name? Solutions?
How to resolve the partial result error in the report
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
What is the test methodology for testing BO Universes?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
can any one tell me how to create a new universe from scrach with step by step process.
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:)
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
What is the difference between datawarehousing and businessintelligence?
Difference between Decode and Case?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?