Populating Numbered List from a Module with 4 or more dimensions:
Use Case: I am trying to create a Numbered List from a module with 4 dimensions typically SKU, Tier, Product and Level & few Line items. For modules dimensioned by 3 lists it is straightforward to create a View as the source of the Import with the 3 lists as Column items and the Line Items as Row items. Unfortunately this does not extend to 4 lists as you can't have 4 lists as Column items in the view pivot.
Create a Helper list with 10k items(can be extended depending on your combination size).
Create 2 lineitems in your source Module:
RANK(1, ASCENDING, SEQUENTIAL)
Create a new Staging Module with Helper list as the dimension:
Create a lineitem to fetch the Concat from the Source Module & another for filtering the saved view:
Source Module.Concat[FIRSTNONBLANK: Source Module.Helper Format]
Create a saved view in the above Staging module.
Create an action to transfer this data from the above Saved view into the numbered list.