posted 2/11/2010 by MikeDavis - Views: [1871]
I was working in SSAS 2008 the other day and I noticed the source table shows up wrong in my cube when I change the key column for a dimension. This does not break the dimension nor the cube, it is simply a strange bug. It does not happen all the time and seems to not cause any issues.
Here I am in the dimension named Store and you can see the attributes for that dimension below. I click on the state name to select it.
In the properties window I click the ellipses next to the key columns property. Notice it says dimStore.State in the key column property.
This opens the key column editor. The source table is should be DimStore, instead it is DimSalesReps, but the attributes below are from DimStore. This does not cause any issues in the cube, and there does not seem to be any need to change the source table. You can still add the columns and click OK. Let me know if you notice this behavior too.
THis saved my life - or at least several days of it! Looked everywhere to change this in bids - I still dont know where you do it, but this worked first time. Thanks for posting this!
Interesting possible bug. I will definitely keep an eye out for it now as I use the Key Columns and Named Columns quite a bit.