Wednesday, 16 May 2012

How can I setup default dimension member in Calculation script? | MS-BI

You can use ALTER CUBE statement. Syntax:
ALTER CUBE CurrentCube | YourCubeName UPDATE DIMENSION <dimension name>, DEFAULT_MEMBER='<default member>';

No comments: