I have the following scenario in MS SSAS 2005:
- One Measure Group called transitions;
- One Measure Group called actions;
The transitions have actions associated. They share all the dimensions except:
- Transition has the workflow dimension associated;
- Action has the action detail dimension associated.
I tried the many-to-many relation between the two measure groups, but the result was always the total number of actions. It didn't filtered the number of actions by the respective transitions.
My objective is to filter the number of actions by the transition, given a workflow restrition (the workflow dimension is only associated to the transition measure group).
I really need some help :\