I create a dataset by a mdx query. (the datasource is a cub) the fileds name related to the (time)dimension value. I used this field as report colunms. the report works in 2009 but it does not work in 2010 because the field name was changed. I do not know why. is there any way to fix it? or something wrong with the report designing?
thanks,
Tom
If the cube design has changed and your MDX now returns a different column name, then you could consider having a calculated field in your report data set, which translates the new field into the old field's name. Then you won't have to change your report layout at all.
But I'd be trying to work out why the cube design may have changed when there are reports dependent on it.
Rob,
I did use calculated field, and the name was not changed but its value was not changed too. (the name should be the same and the value shoud be updated, I wish.)
Thank you very much!
Tom
