Hi,

To get a total value of sales from a selected date, which will be used
in the calculation member like weight. Currently, the script I write

([Measure].[sale], Closeperiod([Date].[date].[day] ,
[Date].[date].Currentmember), Root(OtherDimension1),
Root(OtherDimension2), Root(OtherDimension3), Root(OtherDimension4),
Root(OtherDimension5), Root(OtherDimension6), Root(OtherDimension7))

Question: Is there simple way to eliminate all other dimensions in the
script?

Any help is appreciated,

Charles