How to convert module line item into a list?

Arjie

I want to convert module line item "WBS" into a list?

The formula of this "WBS" as line item as follow:

1.) CJI02. CJi3 for Phasing Report (Module).

WBS = CJI01. Transactions Data'.WBS Imported

2. CJI01. Transactions Data (module)

WBS Imported = 'CJI3 Transactions'.Object

3. 'CJI3 Transactions (General List)

=CJI3 Transactions'.Object

Thanks in advance.

rob_marshall

@Arjie

There are a couple of things that need to be corrected from the picture you have above:

• Time should not be in the list as either a property or as a code. The same statement goes for transactional data. For more information on this, please read
  https://community.anaplan.com/discussion/48866/oeg-best-practice-data-hubs-purpose-and-peak-performance
• Avoid using properties on a list https://community.anaplan.com/kb/articles/71178-1-05-03-avoid-using-list-properties
• only bring in data that you truly need, are you sure you need Fiscal Year and Fiscal Period?
• Posting Row, what will that be used for along with Document Date? Please review what is actually needed and load those to a SYS module.

From that SYS module, you can create a line item to get the first occurrence of the WBS line item (again, please don't use or load data as properties as this makes the building of the list heavier). Create a view using the boolean from the isfirstoccurrence line item to create the WBS list.

Arjie

Thanks a lot Rob. This is very helpful tips.