TM1 Forum

Guys,

I am pretty new to using TM1 and am after some help with the following:

- Attach an element attribute to each natural account that points to an appropriate balance sheet account
- Consolidate these elements to place the appropriate consolidated amount in the designated natural account

Below is an example of what was done:

Natural Account Mapping
40100 11260
40700 11260

In the above 40100 and 40700 are revenue accounts (in the Natural Account Dimension) and roll up into Profit & Loss
11260 is an asset account (in the Natural Account Dimension) and rolls up into Balance Sheet
These two roll-ups are otherwise independednt of each other (as Profit & Loss and Balance Sheet exist as siblings with no parent)

The rule I have created is as follows:

['Movement', 'Natural Account': '11260'] = N:
IF(
ATTRS('Natural Account', !Natural Account, 'Balance Sheet Account Mapping') @= '11260',
#THEN
DB('Cube XXX', 'Movement', !Business Unit, !Channel, !Provider, !Product, !Region, !Natural Account, !Financial Period, !Planning Version),
#ELSE
CONTINUE);
#ENDIF

This produces no result however. I think is has something to do with the fact that the DB function pushes 'Natural Account' into 'Natural Account', but am not sure. I think I am missing a step but not sure what, though I think it needs an ELISANC statement related to Profit & Loss.

Can someone please help?

Cheers,

When you specify !Natural Account... rules do not look at all elements in the Natural Account dim but instead look at the one that is specific to your initial parameters... in this case '11260'.

What you can do instead is create a consolidation for 11260 with the relevant elements underneath or if that does not suit the purpose you could set up a dummy consolidation that you don't actually see and just have that rule driven into the 11260 element.

I would prefer to use TI as against rules, easier to accumulate the values in the Balance Sheet Accounts.
If you wanted to use rules you may need to have 2 account dimensions to manage the many PL Accounts adding to the same Balance Sheet Accounts.