TM1 Forum

Hi,

I'm wondering whether it's possible to feed a subset of a dimension. That is, something like this:

[ 'No Account', 'Quantity' ] =>
DB( 'This cube name', !el1, !el2, !el3 ..., '{800001, 800006}', '{Amount, Average Sales Price}' );

I've tried something like this and it doesn't seem to work. I could create a consolidation and feed that but not sure I want to do that for all cases in which this would be useful. Is there a way of doing this or another approach to consider?
Cheers,
Alex

You have the following options:

1. feed technical consolidated elements (as you wrote)
[ 'No Account', 'Quantity' ] =>
DB( 'This cube name', !el1, !el2, !el3 ..., 'Tech_Cons_Account', 'Tech_Cons_Measure' );


2. direct list on the right side
[ 'No Account', 'Quantity' ] =>
DB( 'This cube name', !el1, !el2, !el3 ..., '800001', 'Amount' ),
DB( 'This cube name', !el1, !el2, !el3 ..., '800006', 'Amount' ),
DB( 'This cube name', !el1, !el2, !el3 ..., '800001', 'Average Sales Price'),
DB( 'This cube name', !el1, !el2, !el3 ..., '800006', 'Average Sales Price');

3. combination of 1. and 2.

Thanks Peter, I hadn't realised I could comma separate a list of targets so this is an improvement on writing four separate feeders.

Cheers,
Alex