What is the Difference b/w Server based Ranking and normal
Ranking?
Answer Posted / 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 |
Post New Answer View All Answers
What sort of existing documents should business analysts refer to when starting on a new project?
Can we Save (save as) WEBI Doc as DESKI?
Can anybody tell me what are the tuning problems?
Explain what are the steps to be taken to schedule the report?
What is the dense rank?
How to execute the plsql procedure from the report by clicking with mouse?
What is aggregate table and aggregate fact table ... Any examples of both?
What are the steps to do to use alerts in bo?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain how to schedule the report in b.o?
What task is 98% of the required work of a business analyst?
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 ?
Can we create universe with no cache??
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is difference between webi and infoview?