TM1 Forum

Hi All,
I am just wondering how to feed with following situation?

In Costing Cube:
['Super'] =N:
DB('Assumption Cube', !Version, !Year,
ELPAR('Region', !Region, 1)
'Super %',
DB('Input Cube', !Version, !Year, !Region, !People, 'Grade'));

Basically, getting the String value 'Grade' from the Input Cube, and then getting the Simple value from the Assumption Cube

Detail Information:
Version: TM1 9.5.1
Cubes: Costing Cube; Assumption Cube; Input Cube;
Dimensions & Elements:
Costing Cube: Version, Year, Period, Department, Region, People, CostingMeasures{N 'Super'}
Assumption Cube: Version, Year, Country, AssumptionMeasures{N 'Super %'}, Grade
Input Cube: Version, Year, Region, People, InputMeasures{S 'Grade'}

Any helps would be much appreciated.

There is another way to do this.. which can simplify the things a bit. I don't know whether you can change your design....May help you..

-->Create a String element ' dummy ' in the measure dimension of Costing Cube.

Rules in Costing Cube
['dummy' ]= S: DB('Input Cube', !Version, !Year, !Region, !People, 'Grade');
['Super'] =N: DB('Assumption Cube', !Version, !Year,ELPAR('Region', !Region, 1), 'Super %', !dummy);

FEEDERS ( in Assumption Cube)
[ 'Super %'] => Super measure in Costing Cube

FEEDERS (in Input Cube)
['Grade' ] => dummy measure in Costing Cube

{input cube} => DB( if ( DB(assumtion cube) <>), costing cube, '') ,...)