Interested to Buy Any Domain ? << Click Here >> for more details...
why we use aggregation in lower level
- 1 Answers
- 5377 Views
- TCS, I also Faced
- E-Mail Answers
Answer / shamanth
Aggregation will be defined at lowest level only, because
we can move/drill anytime from lowest-highest but viceversa
(highest-lowest) is not possible.
Defining aggregation at the lowest level is best practice
to improve performance.
| Is This Answer Correct ? | 1 Yes | 1 No |
what is BIAR file in business objects xi r2
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash
3 Answers iFlex, Maintec, TCS,
What is the server based ranking? and its usage?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
can u create report to connect oracle and sqlserver at a time?
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:)
What are the errors u have faced in creating reports in business objects and explain some?
what is the difference between breaks and sections?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
how will you move the universe/report from development to production?
Teradata 
