how will you add 2 measures in a cross tab report
Thanks for the ideas
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.
Quote from: johny.cbi on 04 Mar 2008 07:37:37 AM
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..
Quote from: johny.cbi on 04 Mar 2008 07:37:37 AM
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
Quote from: johny.cbi on 04 Mar 2008 07:37:37 AM
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
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.