Importing Line Items with 4 or more dimensions to a Numbered List
In my model I have a number of modules that are dimensioned by 4 Lists, typically Time, Region, Resource and Product (e.g. hours worked by Resource A on Product B in Region C in Week D. I want to save changes to line items in these modules to a Numbered List with Time, Region, Resource and Product as Properties along with a Property for each line item in the module that I am looking to save. 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 not have 4 lists as Column items in the view pivot.
The only way I have found is to create an intermediate numbered list with 3 of the original dimension lists as Properties and then use this and the 4th original dimension list as the dimensions of an intermediate module that then pulls in the line items from the original module and has additional line items that return the List Items referenced by the Properties in the intermediate numbered list. This is very clunky, the intermediate numbered list has to be recreated each time in case the original lists have been updated, which results in a Clear action and an Import action, plus the extra effort and space taken by the intermediate list and module.
Has anyone discovered a better way?