BPC custom logic BADI

[former_member582629]

Hi,

I want to read data at specific given intersections from BPC model - Infocube.

We have a data stored in EXPENCE infocube at ACCOUNT = ACC_001 .

In ACCOUNT dimension - there is a member formula created with ( ACCOUNT = ACC_100 = [ACCOUNT].[ACC_001] ).

We want to read data at ACCOUNT = ACC_100 which is bringing data using member formula in the EPM report.

Want to use this value in our UJ_CUSTOM_LOGIC - BADI calculation.

Please advice , how we can read data at ACCOUNT = ACC_100 which is having a data using member formula result.

Waiting for your positive and prompt response on this.

Regards,
Sanjay Gajera

[former_member186338]

Once again!

Custom logic badi is launched from some script and the script is launched from DM package (I do not recommend launching custom logic badi from default.lgf!)

Test scenario:

Script to launch custom logic TESTBADI:

*START_BADI TESTBADI 
QUERY=ON
WRITE=OFF
DEBUG=ON
*END_BADI

We have ACCOUNT PL120 having value 17 for some intersection of other dims.

PL250 - member formula = [PL120]

We execute DM package with the scope PL250 and in ct_data we see the record with the value 17

What is not clear????

[former_member186338]

Debug of custom logic badi - incoming ct_data:

[former_member186338]

Same result using run_axis_query_symm

[former_member582629]

Clear . let me try and confirm on this. Thanks.

[former_member186338]

Sorry, I have tested myself with simple custom logic badi and the member with dimension member formula.

I was able to see the record in ct_data with this member and correct value calculated using this formula.

Then I have tested reading data with run_axis_query_symm - also correct record!

Please test yourself!

[former_member582629]

Hi Vadim,

My scenario is like mentioned below:

Input schedule template is writting data into Account : ACT_001 with EPM save function is 1000$.

Having Member formula on Account = ACT_100 is as: [ACCOUNT].[ACT_001]

Now , in EPM report with EPM retrive for account : ACT_100 is giving me data result : 1000$.

When i am checking into info cube with ACCOUNT = ACT_100 , there are no any records into cube.

In my calculations , i want to use the result of ACCOUNT = ACT_100 which should come as 1000$ as coming into EPM retrive.

Please advise , how can i achieve this with reading data from ACCOUNT = ACT_100 even there are not having any data into backend in infocube .

[former_member186338]

But what is the issue?

Members with dimension member formula will be read in ct_data if QUERY=ON or using method

run_axis_query_symm

P.S. Just test your badi in debug...

[former_member582629]

Hi Vadim,

thanks for the prompt response.

Issue is that , we can read a data which is written at BPC cube , if we want to read data using member formula which is getting calculated on the fly in EPM report , how this calculated dimension result will be read as it is not stored into BPC cube.