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
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 |
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 |
Answer / gopal
Yes we can put more measures in cross tab called Nested Cross tab...
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What is the information present in the cognos configuration file?
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
Can you define folder?
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.
In an existiing Framework model, how will you add a new column to the existing table?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
In which types of reports does the page breaks applicable in Cognos...?
Can you define dimension?
what is the difference between count and running-count functions?
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me