cancel
Showing results for 
Search instead for 
Did you mean: 

Configuring delta load from totals transaction cube in BCS

Former Member
0 Kudos

Hello Gurus,

I am trying to prototype a set up based on an SAP how to doc (updated by SAP in Nov 2007), which is a doc on configuring a delta load from the totals cube to a basic cube.

Please note that this doc, doesnt talk about doing an export datasource from the virtual cube. It mentions about doing it directly out of the transaction cube.

Has anyone done this and set this scenario?

I have certain issues on it.

1. I am trying a full load from the totals cube to the basic cube. Just the latest request's data is being extracted and not the data, part of the older requests!

2. Do I need to extract based on a cons group ? Do I need to add any selections ? The how to doc mentions about an infopackage selection on cons group. But I dont know, if that is needed ? We will be having only one hierarchy on cons group?

3. Can I set up full loads always, without issues of performance?

4. And finally, has someone modified the function modules as mentioned in the document, to prevent the front end impact on the queries?

Thanks in advance,

Prakash

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Prakash,

I am answering some of your question...

Q: Please note that this doc, doesnt talk about doing an export datasource from the virtual cube. It mentions about doing it directly out of the transaction cube.

A: You need to use virtual cube on the top of it to extract the data from TC. Normally data in BCS is extracted using VC.

3. Can I set up full loads always, without issues of performance?

Full load will impact performance. Go for monthly delta load.

4. And finally, has someone modified the function modules as mentioned in the document, to prevent the front end impact on the queries?

No.. Can you tell me .. why you want to modify the FM. All your reporting is best done thru this FM and if you need to modify... have to be very careful...

Former Member
0 Kudos

Mani, thanks for your reply.

As per the how to doc (updated latest by SAP in Nov 07), the export datasource is out of the transaction cube and not the virtual cube!

I would request you to go through that doc to get more clarity on my questions. Also the FM's that I am referring to is the not the virtual cube extraction FM, but a couple of FM's mentioned at the end of the document, to facilitate reporting filters.

The how to doc is available on service marketplace,

Thanks

Prakash

Answers (0)