i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

---

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,

---

What is Cartesian product?

14 Answers  

---

What Is Snow Flake Schema?

0 Answers   Informatica,

---

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,

---

---

Shall we connect to the oltp systems directly .,

2 Answers   iNautix,

---

Is it necessary to give joins to the aggrigate tables in the universe?

2 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  

---

what is the difference between bo and cognos?

1 Answers  

---

What is scope of analysis ?

3 Answers   L&T,

---

How to delete the duplicate colums in a sql table ?

3 Answers   IBM,

---

Steps to create alias and apply

2 Answers  

---