Import data to a module, best practice?
Hello, I have the following data:
Transaction # /CODE(ITEM(# Transactions))/Text/(# Transactions is the numbered list I created with Properties of Account (Text Format), Cost Center (Text Format), Cost Pool (Text Format), Amount (Number Format), Version (Text Format), Period Text Format)
Cost Center/No Formula/Text/ (I have a hierarchy set up for this)
Account Code/No Formula/Text/ (I have a hierarchy set up for this)
Cost Pool/No Formula/Text/ (I have a hierarchy set up for this)
Year and Month/No Formula/Text/ (2 years by month)
Scenario/No Formula/Text/ (i.e. Budget/Actuals)
I have managed to import to a module via a numbered list by first importing the same data into a numbered list then using the numbered list as dimension and the other fields as line items. I am not sure this is the best approach as I will need to aggregate the data for calculations etc. Any advice on best practice? The data won't import using the other dimensions as there are multiple instances of cost center/accounts/in the data.
Much appreciated for any advice you can provide.