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 |
2.How do you drill through report from Report Studio to Analysis studio?
What are the advantages and disadvantages of using Transformer cube?
In which types of reports does the page breaks applicable in Cognos...?
What is use of Field Set present in toolbox?
what is Cognos Visualizer?
What is set to be Cognos configuration?
how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..
----------------What is Surrogate Key?
can we create a chart without measure
What is difference between drill through and drill down?
Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480
What is meant by drill down?