Hi everyone

Let's say I have a DW with:

group1 customer_id
group2 order_id

Is there a good way to add a new group level in the middle so it looks like this:

group1 customer_id
group2 order_year
group3 order_id

Right now my only idea is to create a new group 3, copy all properties of group header/trailer 2 to the new group one by one, move all controls from group 2 to group 3 and go over all computed field expressions replacing "sum(... for group 2)" with the new group number.

Is there a smarter way to do this?

Regards,
Markus