Answer / shruthi

A Universe is a file that contains connection parameters,
sql structures and schema of the tables and joins. A
universe provides an easy way to understand and use
interface for non technical web intelligence and desktop
intelligence users.

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,

---

Explain what is the difference between slice and dice and cross tab report?

0 Answers  

---

How can you access your repository with different user profiles?

2 Answers   TCS,

---

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 aggregate navigation?

3 Answers   Countrywide, CTS, HCL,

---

What is the difference b/w the simple Universe and Complex Universe?

2 Answers  

---

What is the difference between business requirement document and use case document.

0 Answers  

---

please anyone explain me the derived table with the problem tables.

1 Answers   CTC,

---

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

---

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

---

GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?

4 Answers  

---