Custom Rollup formula and All Member Formula property

For SSAS 2000 ,to specify a custom rollup formula in any level except the All Level, the Custom Rollup Formula property of the level has to be used.

Then to specify it for the All Level the All Member Formula property of the dimension has to be used.

But at SSAS 2005, to specify it for the All Level , I dont know where is the All Member Formula property of the dimension .

Anyone know where is the All Member Formula property of the dimension at SSAS 2005.

Thanks

How about making a cube MDX script assignment to the Root() of the dimension?

SQL Server 2005 Books Online

Working with Custom Member Formulas

Note: To apply an MDX expression to members of a particular level instead of to members of all levels based on a particular attribute, you can define the expression as an MDX script on the level.

|||

May I know why the CustomRollupColumn property or UnaryOperatorColumn property after configure can not be remove if I dont want it to be done this way. I tried to remove from table ID and columnid as show below, but I not see none or any other setting to remove it .I only able to change the setting , but not remove the setting.

UnaryOperatorColumn

- Sources

--TableID

--ColumnID

CustomRollupColumn

- Sources

--TableID

--ColumnID

For this moment,I just able have to delete the dimension and recreate it again because of fail to remove the above property setting.

Anyone know how to remove the setting.Thanks

|||

Anyone know about above question?

Appreciate that anyone able to provide opnion.

Thanks