Import Transactional Data into DataHub
I have a question related to import transactional data (Net Sales) into Data Hub, with the following requirements:
- The Net Sales and Qty Volumes are grouped by more than 10 attributes required for Sales Planning Purposes. Best practices in Anaplan is to concatenate those attributes that will be the key for the line items, but in this case are more than 10 attributes so I think is not a good choice.
- For this transactional it will be stored 3 years of data and it will be uploaded incrementally, means each month will be uploaded a delta.
Main concerns are:
- What should be the key for the line items? Concatenation of more than 10 attributes or a sequential number (taking into account that import is done based on deltas)?
- It should be the time a dimension or line item in the module?
Thanks for your support.