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