Partial Data—Clears data from a specified region in an aggregate storage database, and retains the data located in other regions
When you select to clear partial data, enter an MDX expression to define the region to clear, and select either Logical or Physical to specify type of data clear
-
Logical—Data in the specified region is written to a new data slice with negative, compensating values that result in a value of zero for the cleared cells.
-
Physical—Data in the specified region is physically removed from the aggregate storage database.
To use the Member Selector to create MDX syntax, click . In the Member Selector dialog box, select a member or members, or use a function from each dimension, and then click OK to create the MDX expression.
For example:
Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin({[NI].Levels(0).Members},{except(DESCENDANTS([Q1]),{[Q1]})}),{[FY12],[FY13],[FY14]}),{[Plan]}),{[Working]}),{[100].Levels(0).Members}),{[P_TP].Levels(0).Members}),{[FY06]}
Note that the MDX expression is validated when you click OK to clear the data. If you modify the MDX expression directly, it will validate before running.