I am creating a cube with a single fact based on order payments. THe fields order# and seq# in the fact table have no related dimension. The payment amount in that fact table is the measure I'm using. So I have several dimensions - date,
location, customer, etc....not a problem but for some reports I would like to pick up the order number. So my question is given two non-measure fields in a fact table, how do I make them accessible in my cube? I am thinking that I need to
create a dimension based on my fact table but not sure so I'd rather someone set me straight first.

Thanks for your response.

**View Complete Post**

## Need 2 Measure Groups for One Fact table

All,

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.

Thanks,

Mindy