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

Weighted Averages across a D-Cube with automatic D-List updates

Started by Wouter, 24 Jul 2007 09:02:48 AM

Previous topic - Next topic

Wouter

Hello,

I have the following issue. All my type 2 D-Lists are generated from D-Cubes (1 per main dimension) where the content and hierarchy of each D-List is configured. This works.

Now I'm constructing D-Cubes where several type 1 D-Lists have %-measures. Across some D-Lists I want these % to add up via a sum and on others as a wheighted average. This works by using or not using "+0" on the different D-List (sub)totals depending on what is required.

=> Off course when I update all D-Lists automatically, these "+0" dissapear form the updated (sub)totals calculations.

Issue is that when I launch a macro that fixes this, that the formula for the (sub)total is hardcoded in the macro, thus cancelling the initial update of those items in the D-List.

So I'm a little bit stuck on this as this clearly ruines (sort of speak) my clean and automated setup (attempt).

Suggestions anyone?