TM1 Forum

Thank you, it works now. Haven't tried this one because I thought ATTRS wouldn't get me the alias, but it does!

Hello all, I have a problem with a feeder, see below; (Simplified example) I have cube 'Employee' with dimensions; Scenario Period EmployeeMeasure Employee And the cube 'Result' with dimensions; Scenario Period Account I have a alias in 'EmployeeMeasure' called 'TargetAccount' which holds account nu...

I think I Have the solution for the feeder; Create a consolidation in the measure dim, 'TransferedValues' For option 2 ['TransferedValues' ] => DB('Result', !Scenario, !Period, !Measure); The downside is that you have to maintain both the consolidation and the alias, but I see no other options (with...

Marcus, the example is a simplification of the model there are more cubes in the model, more dims in the cubes, and more measures in the measure dim which are not mapped to accounts.

One account maps only one measure and the otherway round. So I have two options left; 1 Make an attribute in the account dim named source, which will give this rule; []=DB('Employee', !Scenario, !Period, ATTRS('Account', !Account, 'Source'), 'All employees'); 2 Make a alias('TargetAccount') in the m...

Hello all I've two cubes; Employee -Scenario -Period -Measure -Employee Result -Scenario -Period -Account And with the next mapping table between Measures and Accounts Measure1 > Account1 Measure2 > Account2 Measure3 > Account3 I want to get the values for the account with a rule; You could do this ...

Indeed this works, Thnx!

I'm a bit shamed, about this error

It is not only the I type, I and E are used both. I don not also want this one; ['FTE', 'I'] = IF(DB('}ElementAttributes_Employee', !Employee, 'EmployeeType')='I' DB('}ElementAttributes_Employee', !Employee, 'FTE'), CONTINUE); ['FTE', 'E'] = IF(DB('}ElementAttributes_Employee', !Employee, 'EmployeeT...

Hello all, I have the next problem; I have a employee cube with the next dims (simplified); - Employee - EmployeeType (elements I and E) - Measure (element FTE) - Period and the Employee dim has the next attributes; - FTE (Value between 0 and 1) - EmployeeType (Value I or E) With a rule I want to fi...