posted 7/2/2010 by MikeMollenhour - Views: [1371]
This is an issue that stumped me the first time I saw it. Here I am going to try and replicate it. First I added a column to the FactInternetSales table named TestColumn:
Next I checked to see if it is available for a measure
So now you say “You haven’t refreshed your Dataset” Thats true and of course we need to do that to refresh the schema stored. So lets do that. I went to the dataset and right clicked on the background and selected refresh.
Now it shows it will refresh the testdatacolumn
Lets Recheck the Measures
Still no column. Final Answer: Since we have a partition on this Fact Table it requires us to edit it as well:
Notice I added the new column to the query below:
And Walla…. It’s now available
I actually did this recently! I felt really stupid after. Do you think it would be better do just do a Select * on the partition? That's what I ended up doing to save myself from this happening again but not sure if it was the best idea.
Devin,
That appears to be a great workaround thanks for mentioning! I automatically assumed that it would be like a sql view. In a SQL view even though you do a select * it wont pick up new columns unless you refresh.