My cube has two dimensions : Time and Geography. It has one measure:
SalesAmount
I need a cumulative sum for SalesAmount over geography dimension. I have
a calculated member for this. MDX for this calculated member is as
follows:
SUM(
HEAD(
ORDER({[GEOGRAPHY].Parent.Children},[Measures].[SALESAMOUNT],BDESC),
RANK([GEOGRAPHY],
Order({GEOGRAPHY].Parent.Children},[Measures].[SALESAMOUNT],BDESC)
)
),[Measures].[SALESAMOUNT])


For the selected time period the following report is generated:
Geography-SalesAmount-CumSalesAmount
Geo-1....-........100-...........100
Geo-2....-........200-...........300
Geo-3....-........150-...........550

Then in OWC I removed Geo-1 from filter. This time following report is
generated:
Geography-SalesAmount-CumSalesAmount
Geo-2....-........200-...........300
Geo-3....-........150-...........550

Cumulative sum field is still 300 for the first row. It must be 200. And
for the following row this field must have a value 350.

I think the set returned by [GEOGRAPHY].Parent.Children function does
not care about filters.

Is there a way to overcome this limitation.

Thanks in advance.

Nilgun Celikok

*** Sent via Developersdex http://www.developersdex.com ***