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....
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 is #prompt and #promptmany, runningtotal in report studio
how u will design the report if the objects are available
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 are the roles defined by cognos platform?
What is slicer & dicer ? what is sub session parameter ?
4. How many dimensions did you use in your reports?
hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
What is Additive function?
Interval Prompt's Usage? Example for usage in Project
how many types of keys are there i.e primary key and foreign key etc..?
What do you mean by Drill down and Drill Up?