Dimension member formula BPC 10 NW

[former_member216978]

Dear Experts,

Firstly I don't find too much literature on Dimension Member formula for NW version .I guess SAP probably don't think its good for performance .

It would be good if could point me to some good ones.

I have a query where I want create a formula like this...:

Account A1

Account A1_LYDEC

How I get this LYDEC in NW version (Last Year December )??

I thought of using LYLP property with CURRENT MEMBER

( [ACCOUNT].A1,[TIME].CURRENTMEMBER.PROPERTIES("LYLP")).

Can anyone suggest a good way to do it??

Regards,

Rakesh Kumar

[Former Member · Accepted solution]

Hi Rakesh,

You can use what you have thought of. Alternately, you can also use something like:

([ACCOUNT].[A1],[TIME].CURRENTMEMBER.LAG(12))

In this, you wont need the additional property.

Hope this helps.

[former_member210696]

Hello Rakesh,

Dimension Member Formula is used for calculations needed on transaction data, it is not used for master data purpose.

So, Let's say you have these three acounts in your account dimension -

ID               Formula

A1              

A2              

A3               [ACCOUNT].A1+[ACCOUNT].A2

Maintaining above formula in FORMULA property will ensure that account A3 holds the sum of transaction data stored against A1 and A2.

When you say you want to club A1 with A1_LYDEC, I believe you are talking about the concatenation of LYDEC with A1 and use that somewhere. This, I believe is not supported through dimension formula.

Can you please post what exactly are you looking for?

Hope it helps!!

[former_member216978]

Thanks Ashish,

.In dimension formula you can you use lookup on basis of other dimensions as well and I am fully aware about that....

Question is pretty simple:

Account A1  100  2011.DEC

            A1   200  2010.DEC

Account A1_LYDEC (kind of a KPI)

A1_LYDEC 100  2012.JAN /2012.FEB...

A1_LYDEC  200 2011.JAN/2011.FEB

basically A1_LYDEC will always fetch last year DEC data for all the periods...

how can I achieve that?(other than script logic)

Thanks for your help anyways.

Regards,

Rakesh