cancel
Showing results for 
Search instead for 
Did you mean: 

read data

Former Member
0 Kudos

Hi,

I have created multi planning area with two planning areas each containing one infocube. Now i have to read data from planning area 1 infocube for characteristics cycle,version and data type = 10. and key figure global currency.

I should also read data from the second planning area 2 infocube with the same characterstics except data type and should do calculation on rate keyfigure and store the value for the data type = 20 of the second cube.

I mean read data for cycle, version,data type = 10, kf global currency from 1st cube and read data for cycle, version from 2nd cube and calculate global currency * rate and store this value for the data type = 20 in the 2nd cube.

rate kf is in 2nd cube and global currency in 1st cube. In the 2nd cube there is kf local currency and the calculated value should be placed in the kf local currency of the second cube for the data type = 20.

Any suggestions will be appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

you need to write a Fox function in which you can specify the plng area characteristic and store data after calculations accordingly.you need to include this function in the multiplanning area.

regards

Sai Vishnubhatla

Former Member
0 Kudos

Hi,

Could you please give me the fox formula to meet the requirement?

Thanks in advance.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Prasad,

one input here..we have a multiplannign area to include the characteristics and keyfigures of both the cubes.hence it does not matter where the KFs are chars are present as long as we define our formulae on the multiplannig area.

Assuming the plannign area 1 are P1 and second one as P2

here is the pseudo code for the fox.Muitplying the first record with second record.

{ cycle,version,20,P2, local currency } = { cycle,version,10,P1global currency} *

{ cycle,version,20,P2,Rate}

please do take care of the Fields to be changed and fields for condition.

regards

Sai Vishnubhatla.

Former Member
0 Kudos

Hi,

Thanks for your reply. Here i have a problem. My requirement is i have to read data as i said before and store according to data type condition 20. I mean for data 20 all the calculated values should be stored. But i don't have data type 20 value in my cube.

Any idea how to store the calculated value for the data type 20 value which is not existing.

There is data type value 20 in the master data but there are no records available in the cube.

But i have to include all the calculated values for the data type value 20. I mean i have include the data type value 20 in the infocube.

Any suggestion will be appreciated.

Former Member
0 Kudos

These calculations cna be performed with the standard planing functions, or with FOX or with a Exit or a combination of all.

May I know the calculcation logic. The method of designing depends on the calculation logic.

Ravi Thothadri