I've migrated my SSAS cube from 2005 to 2008 R2. in 2005 I could use the mdx (alter cube currentcube ...) to set the default member based on attribute property of another dimension. With 2208 R2 I'm unable to set the value.
The mdx that I'm using in 2005 is as follows:
alter cube currentcube update dimension [Time].[Time Hierarchy], default_member = tail(filter([Time].[Time Hierarchy].[Day of Month].members, [Time].[Day of Month].currentmember.membervalue = CDbl([Cube Defaults].[Default Values].Properties(
"Default Time Key" ))), 1)(0);
This used to set the default member to whatever the Default Time Key attribute is set to. For ex. 01-Jan-2010 or 01-Jun-2010 etc.
This doesn't work in 2008 R2 anymore and the default member for the Time dimension is set to "All".
Any ideas? Do I need to change something in the above script to get it working?
All help would be very useful!
View Complete Post