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

regular timing setting for a calculated measure

Started by blom0344, 23 Oct 2008 08:40:34 AM

Previous topic - Next topic

blom0344

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?

blom0344

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.