Interested to Buy Any Domain ? << Click Here >> for more details...
It is possible to give 2 query items has measures in cross
tab?for ex:row as products,column as year and measure as
revenue,sales year....like that.It is possible r not ?If it's
possible pls tel me the process....
- 2 Answers
- 4618 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh
Yes it is possible, drag and drop the measures what ever you want into under Year column. now it is working fine..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rao
Yes it is possible, we can drop many measures in cross as many we want.
For this, you can drop revenue under year and after this you can drop sales (2nd measure) on right side or left side of revenue when black cursor blinks.
you can drop other measures also in this way.
Hopes it will help.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the other methods working as deployment functionality?
What is the use of Cognos scenario?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is cognos powerhouse?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
what is Associated grouping? and how it works in cognos impromptu?
what are typees of dimensions
What actually a project contains?
What is an open session command in cognos connection?what is it meant for?
Diff b/w Crossproduct and Outerjoin?
What is the model filter?
Teradata 
