Skip to Content
0
Former Member
Jan 26, 2011 at 06:22 PM

Formula MDX in Dimensions for Account

35 Views

Hi!!

We are trying to calculate the Average of the price, and to do so we have created the next FORMULA in Account dimension:

IIF([MEASURES].CURRENTMEMBER.NAME="PERIODIC",[ACCOUNT].[INGNETO]/[ACCOUNT].[TONNETAS],SUM(PERIODSTODATE(YEAR,[TIME].CURRENTMEMBER),[ACCOUNT].[INGNETO])/ SUM(PERIODSTODATE(YEAR,[TIME].CURRENTMEMBER),[ACCOUNT].[TONNETAS])),Solve_Order=150

It should work ok, but it does not, when processing the dimension we get error

and the problem is that we use different TIME dimension in each of the applications.

We have two applications that used dimension ACCOUNT.

Application1 uses dimension TIME.

Application2 uses dimension TIMED.

The word TIME is had coded there so it will not work for Application 2 that uses TIMED instead and it sends error.

I think We need some MDX code that asks something like:

IFF APPLICATION= Aplication1 then.......Sum/TIME...... ELS Sum/TIMED.

The problem is that 'I haven't found any code related to Applications... or Cube name..

Please Advise!!!