Hi
I am creating a cube (first one ish) and i have messed around with it a bit and now my Dimention Usage tab is not as detailed as it should be.
By that i mean prior to me messing around with the cub i had a lonbg list of dimentions and each measure that they were related to, now i just have a single row per dimention and no related measures.
looking ar my data source and cub structure it looks like the links between the tables are there.
Is there a way of automatically populating these dimention usage links from the links between the fact and measure tables?
I may well have not explained myself very well or there might be a more visual way of explaining myself so thanks for being patient.
Thanks in advance