can we put more measure on cross tab? If so how many? How
this affect the aggregation?

Answers were Sorted based on User's Feedback



can we put more measure on cross tab? If so how many? How this affect the aggregation?..

Answer / nagarjun

Just select one or more measures from source by holding CTRL
key. Drag and drop on the crosstab measure field

Is This Answer Correct ?    2 Yes 0 No

can we put more measure on cross tab? If so how many? How this affect the aggregation?..

Answer / balaji

you can put more than one measure in crosstab by setting
the define contents property yes.

Is This Answer Correct ?    0 Yes 0 No

can we put more measure on cross tab? If so how many? How this affect the aggregation?..

Answer / gopal

Yes we can put more measures in cross tab called Nested Cross tab...

Is This Answer Correct ?    0 Yes 0 No

can we put more measure on cross tab? If so how many? How this affect the aggregation?..

Answer / beckham

You can put measures in crosstab...

No idea on exact count of metrics but you can use as many
as used in other OLAP tools...

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Cognos Interview Questions

What is the information present in the cognos configuration file?

0 Answers  


hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

0 Answers  


Can you define folder?

0 Answers  


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.

0 Answers  


In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,






using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  


hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  


In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,


Can you define dimension?

0 Answers  


what is the difference between count and running-count functions?

1 Answers  


what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

4 Answers   IBM,


Categories