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
what are the tables used in health care domain project and columns used in report?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What are the steps to be taken to schedule the 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
What is the difference between business requirement document and use case document.
What is object stores?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How to create Index to the table in the universe designer and how it improves the Query performence
any difficulitis have you phase while creating bo reports and how did u solve it
What is difference between custom hierarchy and report based hierarchy?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
can anybody tell me about complicated object you have created