TM1 Forum

Thank you guys. It helped me a lot to understand basics concepts.

Ok, but how to write a rule that will apply ATTRS function on every date/team leaf element. Syntax requires passing: dimension,ELEMENT,attribute. So if i add Month attribute to the Date_Dim the rule in SalesPlanCube should look like: ['Margin']=DB('Margin_Cube', !Team_Dim,Attrs('Date_Dim',!Date_Dim,...

Thank you for the answer. When using ATTRS should I write a rule for every Team_DIM leaf?

Date_DIM is not the same, I've changed the schema. !EDIT rules3.png So the rule placed in Sales_Plan_Cube still looks the same, but Margin_Cube Dimension name changed to Month_DIM. ['Margin']=DB('Margin_Cube', !Team_Dim, !Date_Dim, 'Margin'); I still use the Date_Dim as it finds matching member by n...

Hi, I have following cubes as attached. rules.PNG I've written a rule in Sales_Plan_Cube to set Margin value based on Project margin value for the same month on a leaf level but it doesn't work as expected. ['Margin']=DB('Margin_Cube', !Team_Dim, !Date_Dim, 'Margin'); It assigns margin value from Ma...

Thank you for the previous answer, but what about invoice number . When we divide aggreated cost into many projects using ProjectAllocation Cube, how can we preserve invoice number in target cube? Esspecially that it may happen that many invoice will point to specific Project. Should we think of som...

I'm trying to create POC TM1 Model in which user will be disparsing aggregated measures into more specific ones based on distiribution map. To be more straightforward I have an invoice data with following attributes: cost month, localization, cost group, department, accounting project, account, invo...