Transactional / Basic Cube loading data

[Former Member]

Hi All,

I'll be developing the BPS object for my FI department.

It's needed that data will be planned via BPS also loaded from SAP into the same transactional infocube.

The SAP help says We need to create one more basic cube and data will be loaded into that basic cube. From basic cube it'll come into transactional cube.

How do we achieve this ?

Or do I have to create the process chains to switch the status of infocube to be loaded / planned ?

Will this work for delta updates ?

Pls help me with your expertise

Pal

[Former Member · Accepted solution]

Hi,

Yes delta's will work and yes you will have to create a procss chain which switches the cube to basic (loading mode) and starts the infopackage and at the end switches cube back. During this time users will not be able to plan using this infocube.

The other option is using BPS function to copy the data from your basic to plan cube. This is a bit slower process but no downtime.

hope this was helpful

thanks

PS - Assigning points is the way of saying thanks...

[Former Member]

hi All,

Now I could find the exact problem. I am not yet done with process chains.

Thus I am loadding data into ODS which updates the BPS cube.

I switch manually the BPS cube to planning for testing.

Again I switch manually the BPS cube to loading.

And I see that data is not loaded to the cube.

Why this could happen ? Pls suggest inputs on the same asap

[Former Member]

Hello Subir,

Are you getting any error messsage while loading to the cube?

Regards,

Praveen

[Former Member]

It was a problem of the infopackage from ODS to Cube.

The Z transactional cube was not getting selected for a heck !

Is the process chain structure fine :

ABAP programe to change cube to loading ->

infopackage ->

Activate ODS -> (Added automatically)

Further updates -> (Added automatically)

ABAP programe to change cube to planning

[Former Member]

Hi,

I have right clicked on the ODS -> update data target.

It shows me "No new delta update".

And infopackages are only available for Full / initial.

How do I see the delta infopackage ?

I did the initial upload , changed few records in backend to get delta queue. In vain.

Please share your expertise. Thanks.

[Former Member]

Hello Subir,

Please check if your initalization was successful? Check Infopackage -> Scheduler -> Initialization Option for source system and see if it shows active init.

If that is fine, create an infopackage for delta and try to upload again.

Hope it helps.

Regards,

Praveen

[Former Member]

Hi Anand.

Cheers !

It doesn't work for me , Why ?

The SAP data is getting into the ODS. From ODS it updates the standard cube and BPS cube.

From ODS , delta updates the standard cube but it doesn't update to BPS cube, even though it's in loading mode.

Initial load works fine.

Pls suppotr me , it's a stopper

[Former Member]

Hi,

Check the infopackage is the BPS cube selected in the data target.

thanks

[Former Member]

Hi Subir,

Yes you can load the data in the BPS cube using process chain, you can switch the Infocube status in the Process chain using the program available for switching the status of the Transactional cube to update mode and vice versa.

As for the request from ODS not getting uploaded to the BPS cube, try initiating it manually first and when the delta goes through you can include that in Process chain for subsequent use.

hope it helps.