bigator

How to set default dimension measure in Cube ?

Hi All,

Following script will help you to set default dimension measure for Cube.

ALTER CUBE [Adventure Works]
UPDATE DIMENSION [Geography].[Geography] ,
DEFAULT_MEMBER = [Geography].[Geography].[Country].&[United States]

Thanks, Khilit

bigatorFebruary 19, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: MDX, SSAS

Leave a Reply


%d bloggers like this:
bigator