Interested to Buy Any Domain ? << Click Here >> for more details...
16. How can we create top 10 and bottom 10 records in
the same list?
- 9 Answers
- 36485 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
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What is called materialized view?
can we insert all types of charts in a list report? what r the realtime prompts?
When we save a report in report studio with what extn it save?
Define cognos report net?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
whats the difference between previous version of cognos and cognos 8 BI?
What is defined as data mining?
What is cognos reporting tool?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What are all the types of report?
Can you define cube?
What do you mean by drill across?
write a query to display the departments with no employee?
how can you get the errors in job? when loops are araised we get error?
