Assign Constant value in Rule , Feeder problem

[hyunjia]

Hi All

I need to assign a constant in a rule , and I get the constant value from a lookup cube of 2 dimension , which got only 1 element for these 2 dimensions, a in A dimension and b in B dimension.

So I wrote this rule "['Actual'] = N: DB('constant', 'a', 'b') ;" , Say my original cube is called "Test" , How am I going to feed the rule ?

I try this one but faild "['a','b' ]=>DB('Test', 'Actual' !location, !model,!account1 ,!month );" , please shed some light and guide me through this .

[tomok]

What purpose does it serve to populate a cube with constants and why exactly do you feed the need to feed? You don't have to feed a rule-based assignment like this, especially if it is just being used as an intermediate number to calculate something else.

[hyunjia]

Actually, I am building a mechanism of audit trail , while using rule to calculate the apportion process and TI to do the same thing but populate to a set of audit cube.

The constant need to be retrieve by view in a TI process.

What purpose does it serve to populate a cube with constants and why exactly do you feed the need to feed? You don't have to feed a rule-based assignment like this, especially if it is just being used as an intermediate number to calculate something else.

[qml]

The constant need to be retrieve by view in a TI process.

In that case surely the TI can just take the constant from the original cube/cell once using a single CellGetN/CellGetS? There's absolutely no reason to spread your constant all over the place, feeding it on top of that, just so that it can be used in a TI process. That would be a very bad design.

[Andy Key]

Whilst I agree with tomok and qml that given the information you have given us you don't need to be doing this, you need to think about what the right hand side of your feeder statement is doing.

If the rule in your 'Test' cube is

Code: Select all

['Actual'] = N: DB('constant', 'a', 'b') ;

And if the only thing you can feed 'Actual' from is the ['a', 'b'] combination, then the feeder:

Code: Select all

['a','b' ]=>DB('Test', 'Actual' !location, !model,!account1 ,!month );

needs to be in your 'constant' cube, and in your 'constant' cube !location, !model, !account1 and !month have no meaning. You will need to replace these with explicit references to (probably consolidated) elements within those dimensions.