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

Why is Allocation Tab disabled?

Started by halkosj, 11 Mar 2009 07:03:16 PM

Previous topic - Next topic

halkosj

I am trying to change the allocations for a measure, but the Allocation tab on all the Level Property sheets is disabled (grayed out). Why?

vinay17in

There are 2 things you should no about allocation

1. Transformer automatically allocates a measure as a constant throughout an entire dimension when
the source of the measure does not reference that dimension.
2. When a measure applies to only some levels in a regular or time dimension, you can allocate the
measure from a level where it applies to all lower levels that have no relationship established.
When you allocate a measure from a level, all categories in the level inherit the allocation type.
However, you can change the allocation type of individual categories

How to go about setting this up

For Type 1 - Set Dimension Allocation
------------------------------------------------------------------------------------------
1. Open the property sheet for a dimension that is not referenced by the measure you want to
allocate and click the Allocation tab.
2. Right-click the Allocation type for the measure and select an option.


For Allocation Type 2 - Set Level Allocation
---------------------------------------------------------------------------------------------
1. In the Dimension Map, double-click the parent level of the levels to which you want to allocate
measure values, to open its property sheet.
2. Click the Allocation tab.
A list of measures that are candidates for allocation appears.
3. In the Measure list box, right-click the Allocation type for the measure, and select an option.
The allocation types include Do Not Allocate, Constant, and By Measure.