Hi,

yes. Parent sum can help, but if i write something like [Dim Time].currentmember.parent, it doesnt give me that sum 🙁

stevefromOZ (4/23/2010)

---

Actualy, in looking closer, it looks like the Inventory Value is likely to be a calculated measure. There's something wrong/different between the way in which you created this...

Hi.

Thx, but I am new in AS and I dont understand what youre trying to say.

What I need is some calculation as calculated member like:

Create member [Inventory Value Column Sum]

AS

SUM...

I am sorry guys. I forgot to write that its OLAP definition problem, not SQL! So I need dynamic, way how to sum results in column. Thx

I am sending picture of cube for better understanding.

Columns marked in green rectangule are counted good, but colums marked with brown are wrong.

In Cal 2005 didnt count state of...

I made step forward and created following MDX script:

SUM ( { [Time].[Year Name].PrevMember

, [Time].[Year Name].CurrentMember }

...

I made step forward and created following MDX script:

SUM ( { [Time].[Year Name].&[Calendar 2002]

, [Time].[Year Name].CurrentMember }

...