can't add a new measure after the column is added in the DSV ?!?!

Just found one more nice error in SSAS :-)

If i add a column in my facttable, refresh the DSV and drag the new meassure into my meassuregroup i get an error when processing.

"Errors in the high-level relational engine. The data source view does not contain a definition for the 'MEA_BeregnetErhverv' column in the 'dbo_Fakt_Measures' table or view."

Well this is nice, since i just dragged it from that view :-)

Anyone got a workaround for this, except building the DSV and Cube structure from scrap each time ?

I've tried this exact scenario using Adventure Works sample database on a SQL Server AS 2005 SP1 box and it worked just fine, no errors. What version of the product are you using? Have you applied the latest service pack?

--Artur

|||

I've had this problem and after much trail fixed it by reviewing each of the Relationships in the Cube's Dimension Usage.

The problem turned out to be that one of the Measure Group Columns had a caps change since the last time I defined the relationship and AS couldn't match that column to the column in the Data Source View.

You couldn't see that it was invalid until you clicked on the dropdown list and the column name disappeared. (were as normally it would highlight the current selected column from the available columns).