creating transactional store of plan data
I have various modules which use numbered lists as children of cost centres. Users add items to these numbered lists to capture planned costs for different activities over time.
To export data to our reporting tool I've created a module which collects the values dimensioned by cost centre, gl and time. It is multidimensional but does not need to be in this case as there is a lot of sparsity between unused cc, gl and time combinations.
Are there are any ways I can combine the existing lists to create a transactional data store based on my planned values, with cost centre, gl and time as line items.
what options do I have to combine from multiple modules with different dimensions?