Hello All,

The issue we are facing now is that, we need something like

[Measures].[Current Count] AS '(Normal Measure, [Date
Dim].[Year].CurrentMember)'

[Measures].[Total Count] AS 'COALESCEEMPTY([Measures].[Total Count], 0) +
[Measures].[Current Count]'

SELECT

{[Measures].[Total Count]}

ON COLUMNS,

[Date Dim].[Year].MEMBERS

ON ROWS

FROM

[MyCube]

We don't want to use any aggregate function to calculate the running count,
As it had a performance hit since the above query is a part of a bigger MDX
query.

The problem is we cannot refer to the previous value of [Measures].[Total
Count] When the statement

[Measures].[Total Count] AS 'COALESCEEMPTY([Measures].[Total Count], 0) +
[Measures].[Current Count]'

Is processed.

It would be very helpful if you could help us in solving this issue.

Regards,

Raja Nadar

Hi Raja,

Can you give examples of what the cube data looks like, and what the
values for the calculated measures should be? Also the cube dimensions -
that will make your scenario clearer.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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