Best Of

@Vinay VaradarajM ,

If that is the case, then concatenation is the only way to go.  To get around the 60 character limit, have you thought about having an "Anaplan" code?  This is how it would work...In your flat lists, you would have the real code from the source system.  In the SYS Properties module for that list, you would have an "Anaplan" code to which you would use for the hierarchy code.  For example, in your Product Category Flat list, say a members code is 1000000000009, but in Anaplan, the "Anaplan" code would be 10.  The SKU flat list, a member from the source could be 20000009, but in Anaplan, the "Anaplan" code would be 20.  So, in the Anaplan hierarchy, the code would be 10_20.

And if you needed to export the data out of Anaplan, then you could always refer back to the flat list to get the true source code.

Hope this helps,

Rob

"Rule 2.01-15": Article 2, Chapter 1, and Rule 15 – “Filters in separate modules”. ” Try and keep filters in separate System modules. They can then be reused for different modules.  In the notes section list where this filter is used to prevent accidental deletion”. It goes against Auditable & Necessary elements of PLANS if you wish to go against the rule

Here is how it was done in Pre Planual Era: Filters applied on any modules used to be created & kept in the same module. Filter used to be module specific meaning if there was ever a need to display current month figures again, another line item with the same formula used to get created. A module having a timescale of one full year including quarter totals and full year totals being filtered upon Current Month.

First Module:

Second Module:

What is wrong with this method? It is unnecessary to make filters module specific. Two line items have been created in two different modules to do the same thing. It also becomes tedious to audit each and every filter for every module

Here is how it should be done in Planual Way: Create centralized filter modules and then reference the filters throughout the model. In our example it is recommended that we create time filter module which can be referenced in almost every module as and when needed.

Caution: Filter line items, when used, are not being documented in the model if they have been referenced anywhere. For example below line item from Time Module has been used as a filter.

But the filter line item shows it has NOT been referenced anywhere. Although it is true that it has not been referenced in any other line items but the fact is that it is still in use to filter other modules.

Hence in order to avoid accidental deletion of such line items, it is highly recommended that you add notes to such line items