Hi

I am using the formula below in order to accumulate the information until the
current month. In one of the lines I have a calculated member that returns
the percentage when divided two quantities, but this percentage also
accumulating . What I need to do in order this percentage does not accumulate?


The formula in order to accumulate es: Sum({Ytd()} ,[Versión].[Versión].&[1])

Thanks in advanced for your help
SGS


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1

Is the YTD() formula used in a calculated member, which is on a
different dimension than the the percentage member? And, if so, what are
their Solve Orders?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

No, the formula is used in a calcutaded member in the same dimension.

Eje.
Real ABP
Sales 15000 14000
Variable Costs 6000
Total Variable Cost

No, the formula is used in a calcutaded member in the same dimension.

Eje.
Real ABP
Sales 15000 14000
Variable Costs 6000 8000
Total Variable Cost 7000 9000

No, the formula is used in a calcutaded member in the same dimension.

Eje.
Real ABP
Sales 15000 14000
Variable Costs 6000 8000
Total Variable Cost 7000 9000

From the example report, it seems that Real and ABP are calculated
members on a different dimension than Sales, Costs, Margin and [% of
Sales]. If that is true, then assigning the SOLVE_ORDER for [% of Sales]
higher than for Real and ABP (default is 0) may stop the accumulation.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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