Interested to Buy Any Domain ? << Click Here >> for more details...
How can we improve performance?
- 2 Answers
- 7083 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tilak
1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables
| Is This Answer Correct ? | 5 Yes | 2 No |
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:)
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.
Can any please explain FOR EACH AND FOR ALL?
how to create dashboard reports
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
How were the reports scheduled and how to resolve unexecuted documents?
how do we apply sql query on selected variables?
when and where we use @varialble function
What are the steps to do to use alerts in bo?
How to get top 5 rows of a selected column?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
whats the Diffrerence between business objects and cognos?
Teradata 
