The monthly measure works fine, but the daily measure with the same syntax commonly rum forever. If we recreate the measure, it may work fine and fast one or two times, but then stop to work normally. We can't see the reason for this, so we suppose it to be a bug.
We have calculating measures that calculate running sum on date dimension (by month and by day) Cubes look like this:
We have measure, that count distinct id from table, and calculated measure thith the follow MDX syntax:
Sum([DataDimensionView].[DataDimensionView].CurrentMember.FirstChild : [DataDimensionView].[DataDimensionView].CurrentMember,[Measures].[m_Delta_sum])
The monthly measure works fine, but the daily measure with the same syntax commonly rum forever. If we recreate the measure, it may work fine and fast one or two times, but then stop to work normally. We can't see the reason for this, so we suppose it to be a bug.