Skip to Content
0
Former Member
Dec 07, 2011 at 05:24 AM

Calculation

17 Views

Using MDX I need apply a percentage increment to all account.The question is where do I need to specify in the following formula to calculate for all accounts or there is no need..

*WHEN TIME

*IS =%TIME_SET%

*WHEN CATEGORY

*IS %CATEGORY_SET%

*WHEN DATA_SOURCE

*IS BASELINE

*WHEN RPTCURRENCY

*IS USD

*REC(EXPRESSION=%VALUE% *(([DATA_SOURCE].[ABC],[COSTCENTER].[NOCC],[PROFIT_CENTER].[NOPFC]) + 1), DATA_SOURCE =BPC)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

The increment % entered in the data source is not applying when execution.

Appreciate input..

Edited by: BPC Lover on Dec 7, 2011 6:28 AM