two measures in a report

[johny.cbi]

how will you add 2 measures in a cross tab report

Thanks for the ideas

[almeids]

Only one measure will display in a crosstab, so you need to shape your query results to include the second measure in a separate category (to be used as levels in your rows or columns dimension).
For example, to display Cost and Revenue, get the cost/revenue values into your measure data item in separate records and include a text data item 'Cost' or 'Revenue' which identifies the record content, then nest that data item in your crosstab rows or columns as desired.

[blom0344]

how will you add 2 measures in a cross tab report

Thanks for the ideas

The only way would be to create a type of discontinuous crosstab. Unfortunately Cognos documents only show examples of this type of crosstab that still only contain 1 measure.
I am currently working on a crosstab that holds some 15 measures.

To be honest this is stretching the limits of what is possible and takes loads of time to build. The column dimensions are fixed , the rows are build up by data item labels like:

                          |     dim year
                          |     dim month
------------------ |------------------
data item label1     |    data item value1
--------------------------------------
data item label2     |    data item value2
--------------------------------------
data item label3     |    data item value3

etc..

[sspk]

how will you add 2 measures in a cross tab report

Thanks for the ideas

This may help you
http://support.cognos.com/opendocs/en/html/cognos8_bi/8.3/ug_cr_rptstd_id10247cr_rptstd_wrkdat_resolve_multiple_c.html
u must have id and password

[biejorrun]

how will you add 2 measures in a cross tab report

Thanks for the ideas

You can achieve this by following these steps:

1. On your report page, create an empty crosstab.
2. Drag-n-drop your dimensions from your query (note: only the blue areas in the crosstab!).
3. Now, in your query, select both measures, and drag-n-drop them in the measures area of the crosstab.
4. Voilà, here's your crosstab with 2 measures!

Regards,

Björn

[rockytopmark]

You can have as many measures as you want.  They would need to be placed side-by-side on the row or column edge, and Inner Nested if there is a 2nd or more dimension (1 on opposite edge, the 2nd on the Outer Edge of nested Measures.