Answer / guest

You can make two different universes pointing to two
different data sources.Then in report create two different
queries and take these two different universes as there
source.Then using merge dimension dimension synchornise it
to get correct data in report.

Answer / sudhakar

In info view we are creating two queries from different universes and generate a report trough merge dimension,
In universe level we can take "include like" file>parameter>link tab>include link,
In cristal and Xcelsius reports we can take different data sources trough connections.

What is the short cut join?

2 Answers   Wipro,

---

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:)

3 Answers  

---

How would I achieve Traffic Lighting in Business Objects

3 Answers   Virtusa,

---

Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,

---

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

---

---

6.what is conformed dimension? R u used?

8 Answers   TCS,

---

bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?

7 Answers   PCS, TCS,

---

What are the security level used in BO?

6 Answers   Oracle,

---

How to create predefined filters in B.O.

2 Answers   TCS,

---

When we use aggregate awareness function in designer?

0 Answers  

---

What is the local filter and global filter in bo's?

8 Answers  

---

8. How much supervision have you typically received in your previous job?

0 Answers   CST,

---