If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Combining measures and defining dimensions

Started by Krobzoo, 12 Dec 2008 11:17:40 AM

Previous topic - Next topic

Krobzoo

I am looking for some help and hope someone out there can assist.

We are starting to use Cognos 8.4 and I am in the process of trying to put our data into Transformer but seem to have a problem. We have columns in our file with specific data which would be considered a measure but the column itself is a dimension. For example we have 5 columns which give population counts by race. One Column is the the number of African Americans, one is the number of Asians, one is the number of Whites, etc.

I want to have a single measure of population and a dimension of Race with the various race groups as levels under Race. I assume this is possible but cannot figure out how to do this in Transformer. Any suggestions would be greatly appreciated.

bennerda

The counts you are describing are really measure type objects.  If you wish to have one count, provide that in the query, typically and 1 in an item.  Then create 5 other calcs that test for Asians - Asian Yes, Asian No, African American Yes, African American No, etc.  Use the calcs as your dimension source.  5 dimensions with either value inside - one measure, just the count.  Don't be tempted to put just Yes/No in your dimension columns.  very hard to distinguish later.