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.
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.