COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: blom0344 on 23 Oct 2008 08:40:34 AM

Title: regular timing setting for a calculated measure
Post by: blom0344 on 23 Oct 2008 08:40:34 AM
A have a cube (1 single query) where details and totals really make no sense for any calculated measure that is composed of the product of  1. percentage and 2.integer-value (like "Percentage"."Number_of_xxxx")

In rollup properties the regular timing is set to 'After rollup' . Should this not be 'before rollup'?

The idea is to perform the product before rolling up individual values, isn't it?
Title: Re: regular timing setting for a calculated measure
Post by: blom0344 on 13 Nov 2008 04:37:19 AM
It seems that these are murky waters.... :'(

Ultimately we decided to define the calculated measures in the IQD definition and that resulted in the proper behavior. Setting the regular timing to 'Before Rollup' kept throwing error messages. I suspect that the model than has a problem handling the product of a null value somewhere in the dataset as we could set the regular timing to 'Before Rollup' for a set of calculated measures if we omitted the rest from the model.