Answer / anil kumar ganga

1. OLAP systems are used to analyze the business.it solves
the questions What,when,who,where. Dataware house and OLAP
are same no difference.

2. Microcube resides in BO. I will ask you one question.
-->You have a report like World total sales. And you want
to show only India sales to your user. what you wil do? Yes
you need to apply filters. You have applied a filter to
show India sales. Now except India no country sales is
visible on your report. where it goes? It goes to microcube.
And if you remove filter and refresh the report,the
information which is stored in microcube will come into the
report. It is like a cache. Hope you completely clear on
this

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  

---

How toconnect one to one report?

4 Answers   iFlex,

---

Why do we need metrics and sets?

1 Answers  

---

How many tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  

---

BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,

---

What is the difference between the Bo 3.0 and 3.1?

1 Answers  

---

How you get the requirement from client?

3 Answers   TCS,

---

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  

---

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  

---

What is domain? How many are there in a basic setup? What are they?

1 Answers  

---

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

---

what are the day to day activities of BO administrator ?

0 Answers   TCS,

---