Load Data from Transactional Cube (Planning Request) to ODS

[Former Member]

Dear Experts,

I am entering data in Planning Folder when I press save, data should go from Transactional Cube to ODS.

How to automate the process to change the planning request from Yellow to Green in the Transactional Cube.

Thanks in Advance,

Selva

[Former Member]

Ravi Thanks for the support.

I have created Event & specified in Process Chain, So that it will start and change the request from yellow to green.

How to trigger the Process Chain from planning folder?

Is there any way to attach program in the planning folder?

Thanks,

Selva

[Former Member]

Hi !

You can use FM RSPC_API_CHAIN_START to start a process chain with a starter process set as meta chain start.

Regards, Philipp

[Former Member]

You may want to try the following:

1. Write a program call the FM " RSAAP_Close"request" to close the request after the load.

2. Once it is closed, then you may use the proces chain to laod the ODS from the cube.

Put the above processes in a process chain.

Ravi Thothadri

[Former Member]

I think it stays in yellow for every 50,000 records or something like that in planning cubes. you may want to verify it though.