Variable Feeder?

[Willi]

Hello,

I have 2 cubes with nearly the same dimensions. 2 of the dimensions in Cube 1 are Year and month. In Cube 2 I have here a Dimension with 2 Special Dates and the }Clients-Dim. I now want to write a rule wich copies all data for the 2 Special Dates and the current user in Cube 2. The Dates are stored as Attributes in the }Clients-Dim. The copy itself is working but the Feeder not. I tried this:

Code: Select all

[{'e1','e2'},['measure1','measure2','measure3'}] => DB('Cube2',!dim1,TM1USER(),'specialdate',!dim2,!measure);

But this is not working. The Leafs in Cube2 are not fed according the Tracer. I tried to insert an ATTRS or DB to read the wanted date in the left side of the Feeder but only get Syntax-Errors.

Code: Select all

[{'e1','e2'},DB('}ElementAttribues_}Clients',TM1USER(),'Date'),['measure1','measure2','measure3'}] => DB('Cube2',!dim1,TM1USER(),'specialdate',!dim2,!measure);

or

Code: Select all

[{'e1','e2'},ATTRS(}Clients,TM1USER(),'Date'),['measure1','measure2','measure3'}] => DB('Cube2',!dim1,TM1USER(),'specialdate',!dim2,!measure);

Is this possible what I wanna do?

Thx and regards

[EvgenyT]

I tried to insert an ATTRS or DB to read the wanted date in the left side of the Feeder but only get Syntax-Errors.

Code: Select all
[{'e1','e2'},DB('}ElementAttribues_}Clients',TM1USER(),'Date'),['measure1','measure2','measure3'}] => DB('Cube2',!dim1,TM1USER(),'specialdate',!dim2,!measure);



or

Code: Select all
[{'e1','e2'},ATTRS(}Clients,TM1USER(),'Date'),['measure1','measure2','measure3'}] => DB('Cube2',!dim1,TM1USER(),'specialdate',!dim2,!measure);

You can only use short-hand notations on the left side

Regards,

[lotsaram]

1. You can only use literal strings within square bracket rule notation. the left hand side area definition must be in square brackets.
2. Conditional feeders need to be handled within the DB on the right hand side of the feeder.

The TM1User function works in the right hand of a rule because the rule is evaluated in real time in the context of a user submitting a request. But feeding is a "background" system event on database level without context of a user. I'm not sure what string the function would return as the user handle in the context of a feeder but I am sure that TM1User function has no place being in a feeder. In any case it seems that since you are trying to use TM1User on both sides of the feeder this would be like a !Dim reference so I doubt you need this anyway, but need to know more fully just what you are trying to do.

[Willi]

Thx for your replys. I solved it with a Little TI: As far as I know the user has to press a Button (Recalc or Actionbutton) anyway if the TM1RPTROW of an ActiveForm is build with a MDX: So I can offer him an ActionButton wich updates the Cube with the necessary Values.