Answer / rajkumar

Merge Dimesnion: Is used for merging two are more queries (data providers), to present in a one block.
Note:- In all the queries data type should be same of merge objects.
Example:

Force Merge dimension:
It is a concept in webi account for synchronized dimensions in measure calculations when the synchronized dimensions do not appear in the calculation context of the measure

What are @FUNCTION?

4 Answers  

---

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  

---

Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers

5 Answers   Wipro,

---

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,

---

Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

7 Answers   Zylog,

---

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

0 Answers  

---

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

---

How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

1 Answers   IBM,

---

Difference between zabo and webi?

0 Answers  

---

when will use compatible and incompatible objects?

1 Answers   Business Intelligence Analytics, iGate, TCS,

---

how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

3 Answers   Keane India Ltd,

---

what is variable ?

3 Answers   Tech Mahindra,

---