Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the steps to do to use alerts in bo?
What is the difference between datawarehousing and businessintelligence?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
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...
What is thumbnail?
How to restrict password to a user while sending a document in .pdf format
Explain about a tricky situation for which you found a very simple solution?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain the data types present in bo and what happens if we implement view in the designer and report?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What are the data types present in bo? What happens if we implement view in the designer and report?
Differences between business objects and web intelligence reports?
how to create metric universe ?
what is the difference b/w the refresh and buffered data?
