Embedded BPC - derivation

[seudunur]

Hello Experts..

I am new to BPC..I am currently designing input ready queries in Embedded BPC. I have the following requirement. Can you please suggest a solution.

My planning ADSO has 10 characteristics ( GL Account, cost center , profit center , version , audit trail , planning , area , planning business unit, functional area, fiscal Year/Period,currency ) and one key figure (Amount). My aggregation level has the same 10 characteristics.

Query will have three rows ( GL account, cost center , currency ) , columns( fiscal Year/Period , Amount) , user input variables (version , cost center) , filters ( Audit trail , planning area).. we need to derive the following and write back to adso once user save the data.

GL account has two attributes ( isdriver , functonal area)

costcenter has two attributes ( planning business unit , functional area)..

1. derive planning business unit

2. if GL account . isdriver is 5 , then get functional area from GL account else get functional area from costcenter.

Thanks,,

Srinivas

[former_member139490]

Hi Srinivas,

Please find below the comments:

Issue 1:

Derive planning business unit

Solution;

Create attribute based characteristics relationship on Cost centre

Mark Cost centre as input and planning business unit as output

This will derive the planning business unit while saving the data to ADSO.

Issue 2:

If GL account . isdriver is 5 , then get functional area from GL account else get functional area from costcenter.

Solution:

create a FOX based planning function using the logic asked by you

Integrate the planning function in the save data functionality using macro.

let me know if the above comments solve your problem.