I have the following problem:
Users create their own groups of locations in a source system and want to do the reporting on group level.
There is a n:m cardinality between groups and locations.
My idea is to build one InfoCube per group (there are not so much groups but pretty much locations per group).
All data are extracted from flatfiles into a DSO on location level. But the cube should be an group level.
Up to the DSO everything is working fine. My problem is now:
How do I create the transformation between the DSO and the Cube, so that the stores are summed up on group level?
I have a file for the mapping between groups and locations.
Location - Group
A - 1
B - 1
B - 2
C - 2
Thanks in advance