how to find the rank in report studio?
i need steps for this question.
- 2 Answers
- 5460 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uday
1.select the list
2.drag the query items into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as.
6.in functions we have rank function(in summaries)
7.drag the rank function like rank(query item)
8.if query item is number then it will give the ranks
to that number.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gangadhar
1.select the list
2.drag the Data item1 & Data Item2 into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as----rank ([Data item1] for [Data
item2]) = 1.
6.If query item is number then it will display the ranks to
that number.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can you define drill across?
how to create relationship between emp and salgrade tables in frameworkmanager?
How do we drill through from a powerplay cube to reportnet?\
Wt is the Diff between Business Key & member caption?
What is defined as Query studio?
wt is tupple , Embed function ? wt is regular dimension ?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
-------------Diff b/w Union and Unionall?
What are the batches and it’s details?
2.How do you drill through report from Report Studio to Analysis studio?
1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
Teradata 
