What is the Difference b/w Server based Ranking and normal
Ranking?
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
Is This Answer Correct ? | 3 Yes | 0 No |
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
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:)
how to connect the hyperlink in webi reports?
What is the difference b/w the simple Universe and Complex Universe?
What is difference between webi and infoview?
What are the major problems will occur while migrating to the one version to another version?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to create Universe using Flat file in BO6.0
what is drill down?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
WHAT ARE THE VARIOUS PRODUCTS IN BO?
When is the Repository created?