Answer / prathish thomas

Normal Ranking (Reporting-> Ranking)is at the report level , where Web Intelligence allows you to return unranked data from a database, then rank it in Web Intelligence

Server/DB database ranking appears after the Query Filters icon of the Query Panel)allows you to specify a ranking at the query and database level so that the data returned to Web Intelligence by the query is already ranked.
Database ranking has the following advantages:
Ranking data can be processing-intensive. By ranking at the database level you allow the server, which is typically far more powerful than the client machine, to perform this processing.
Pre-ranking data reduces the amount of data retrieved across the network and stored in Web Intelligence

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 Answers  

---

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,

---

How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

---

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  

---

i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,

---

any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  

---

how to create metric universe ?

0 Answers   TCS,

---

What is the use of Surrogate key in BO?

8 Answers   IBM,

---

why we are using derived tables ?how it will help?

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 are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

---