I have one fact table that contains all the measures. The problem is that I want to have two measure groups that point to this one fact table. Some measures would be in measure group A and some in measure group B but the underlying
source still comes from the one fact table. I haven't found a way to do this.
My solution currently is I have created another fact table that is an exact copy of the main one, that way I can create two measure groups. The issue is performance, it takes 4 minutes to build and if I took one of those fact tables out it would be
cut in half.
I would have thought there would be a way to create a measure group and drag what you want in there..but it seems that this isn't the case that you can only create measure groups based on how many fact tables you have.
Any help would be appreciated.
View Complete Post