Answer / radha

IN UNIVERSE DESIGNER RIGHT CLICK -CREATE DERIVED TABLE -
GIVE NAME FOR DERIVED TABLE.

IT'S DISPLAYED IN THE UNIVERSE DESIGNER PANNEL.

MAINLY DERIVED TABLE USED FOR WE CAN CREATE OUR OWN QUERY.

LIKE WE CAN SELECT ONLY THE PARTICULAR TABLES IN THE DESKI
WHILE TRACKING THE DERIVED TABLE(IT'S BASED ON THE OUR
QUERY)

what is canned universe and canned reports in bo?

1 Answers  

---

wha is the difference b/w merge dimension and combining two different data providers?

1 Answers  

---

What is the dense rank?

0 Answers  

---

What is the report extension in webi and deski

2 Answers  

---

Tell me about linked universe ?

5 Answers   Tech Mahindra,

---

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  

---

Can anybody explain what mean by Database Delegated Measures?

2 Answers   TCS,

---

How to get the data from the two different sourcess

2 Answers   IBM,

---

what is universe testing(not mention check integrity)

1 Answers  

---

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 ?

1 Answers  

---

What is difference between webi and infoview?

0 Answers  

---

tell me about aggregate awareness in detail?

2 Answers   Cap Gemini,

---