Finally working:

iif (

IsLeaf([Dim Cost Elements].[Cost Element].CurrentMember) AND

IsLeaf([Dim Cost Center].[Company Code].CurrentMember),

[Measures].[Quantity] * [Measures].[Selling Price],

Sum( Descendants( [Dim Cost Elements].[Cost Element].CurrentMember,, leaves) *

Descendants( [Dim Cost Center].[Company Code].CurrentMember,, leaves),...

There is a message i cannot aggregate calculated member.

Steve,

what do you mean? How do you think that script should look like?

Thx a lot

Unfortunately it didnt help me:(.

What i dont understand is that total sums for regions are correct but not for accounts. Everything is correct on leaf-level. So, the problem is really...

Ok, sorry i am really newbie here. i try it once again.

Dimension with accounts is created like this:

CREATE TABLE [dbo].[DimCostElements](

[ID_Cost_Element] [varchar](25) NOT NULL PRIMARY KEY,

[Parent] [varchar](25) NULL,

[Description] [varchar](80) NULL

)

Dimension...