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



It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as ye..

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

It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as ye..

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

Post New Answer

More Cognos Interview Questions

wt is tupple , Embed function ? wt is regular dimension ?

1 Answers  


-------------How you design DWH?

0 Answers   Bank Of America,


These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

2 Answers   IBM,


hi my name is siraj i want to know cognos queriy language

0 Answers  


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

1 Answers  






How to pass parameter value into html design page?

1 Answers  


What's the differance between each studio in cognos 8?

1 Answers   TCS,


What are products of cognos?

0 Answers  


what is sdibling function tell me the some functions

3 Answers   IBM,


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.

5 Answers   HSBC,


can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,


What is portal page?

5 Answers   TCS,


Categories