I needed some help in designing a consolidation table for the input table as attached as image.
i am trying to consolidate the Org Var based on CF Lines,Driver,Driver Groups for the fixed dimensions (in black).
If i use these dimensions (CF Lines,Driver,Driver Groups) ,the model size increases to a huge extent.
The users would like to see the headings as wells of these dimension along with a drop down for Local and USD currency.
Please suggest some ways to get accurate consolidated results .
I would be making some assumptions here based on the input table and here are my suggestions,
1) Assuming "driver" and "driver group" might hold one-many relationships. In that case, you might not need to include both of these in your dimensions.
2) Also, each "CF lines" might have only one driver or driver group (one to one ) and need not to be dimensioned.
You can create a consolidated report based on "CF Lines" and can have custom filters as page selectors to filter by driver or driver group.
Hope this might help.