Answer / gs2kumar@gmail.com

Boss if we have 2 different hierarchies based on single object (a) when you drill the report it will ask which hierarchies to follow. Simply:)

Answer / manoj

In simple way,it will take a,b,c.

Answer / arjuna2k8

Hi,
Heirarchies will be used in drill reports.
We will select Drilling levels in Query panel.
There are 4 types of levels are there.
1.level
2.level
3.level3
4.custom level

drill down --->navigation of levels,like one by one
drill through--->selecting new level of heirarchy at the
time drilling
drill by--->directly selecting required drilling level

so,from your point a-b-c is drill down
a-->c is drill by

Regards,
Arjun

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  

---

What is the short cut join?

2 Answers   Wipro,

---

how to limit number of rows in a report in business objects using webi?

3 Answers   Cap Gemini, TCS,

---

what r the disadvanges in boxir2

3 Answers   Accenture,

---

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  

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT

9 Answers   Business Intelligence Analytics, SRA,

---

In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,

---

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  

---

What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?

2 Answers   CTS,

---

What are the different types of Filters available in BUSINESS OBJECTS?

3 Answers  

---

what is zero client and thin client ?

3 Answers   Tech Mahindra,

---