16. How can we create top 10 and bottom 10 records in
the same list?
- 9 Answers
- 34679 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / itesh
simple man
top 10 alway will be on some measure based on some dim not
simply top 10 and bottom 10,
make q1>
get the rank of the measure rank(measure for dim )<=10
make q2
the rank in the desecending order of measure
rank(measure for dim desc )<=10
make q3=q1 union q2
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
which type of project we r going to snowflake schema
Write some methods to apply securities in framework manager model?
what are the dimensions that you have in your current project?list them?
How to deploy from one server to another server?
what is a prompt value in report studio and variables ?
what is requery in cognos?
Can you explain new content durability?
What are the different uses of a repository manager?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
-----------------What is Determination Model?
What do you understand by ‘ibm predictive maintenance and quality’?
What is meant by Reportstudio shortcut?
What is called materialized view?
What are the different types of important services used in cognos?
