What is the server based ranking? and its usage?
Answers were Sorted based on User's Feedback
Answer / vidhya
Server Ranking:
Create dense_rank() or rank() option in sql using query
in the design phase is known as server based ranking. The
reason for this is, ranking of data is decided by the
server based upon the condition.
Usage:
Performance will be good.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to implement LDAP authentication in BOE
Is it necessary to give joins to the aggrigate tables in the universe?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
How to schedule the report in b.o?
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
what happens if cardinalities are not resolved?