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 solve the incompatible objects and how they are formed actually.
Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..
What is a fantrap in business objects?
what is diff between webi,deski,infoview
How to open a universe with out using the Designer ??
Explain the difference between compatible and incompatible objects?
how do u resolve contexts ?
What is aggregate table and aggregate fact table ... Any examples of both?
I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers
When we go for OLAP , and When we go for OLTP for generating the reports ?
I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.