I have a dimension "Group Codes" and they contain 4 digit combinations. I created some subsets which divides this is several groups, depending on what digit the group code starts with.
Now this subset is generic, meaning that if I refill the cube, new groups will automaticly fall under the correct subset, am I correct?
Now in my report I only wish to show the add calculation of one of these subsets. For instance:
All group codes starting with 1 are in a subset. I need all the values added up from that subset in my report. Is this possible if
a) It keeps calculating it genericaly (which means if a group is added to a subset, will the calculation add the new group)
b)showing ONLY the calculation, I don't need all the groups in my report.
Or is there maybe a wy to define it in transformer already?
Thank you for reading this
Now this subset is generic, meaning that if I refill the cube, new groups will automaticly fall under the correct subset, am I correct?
Now in my report I only wish to show the add calculation of one of these subsets. For instance:
All group codes starting with 1 are in a subset. I need all the values added up from that subset in my report. Is this possible if
a) It keeps calculating it genericaly (which means if a group is added to a subset, will the calculation add the new group)
b)showing ONLY the calculation, I don't need all the groups in my report.
Or is there maybe a wy to define it in transformer already?
Thank you for reading this