Performance in

[Former Member]

Hi I am not much familiar with ABAP. I want to populate around 8 key figures in a cube and have hence written a start routine in the update rules. I have around 1.5 million records coming into BW and the code I have written needs to go through 1.5 million times since it has to put the key figure value in all the 1.5 million records. Hence the data load is taking long time.

Can someone suggest me a better approach to populate these keyfigures? Any advice is highly appreciated.

Thanks

[Former Member]

The question is how are you going to get these key figures? Are you planning to generate the value within bw or you planning to get the data from source system.

Let's assume you are asking to get the values withing bw.

In 7.0 there is what is called End Routine which will have the same structure as it is in your data target (Cube) and you can build you logic there.

In older system there is nothing much you can do except start routine to put some logic and go through all the 1.5M records. Sorry, that is not what you wanted to hear, but really there is nothing much could be done.

Remember always you can do optimization in your code, if you are doing search, do a binnary search and stuffs like that.

thanks.

Wond

Message was edited by:

wondewossen demissie

[Former Member]

What is your business requirement, is it necessary to write a code to populate your keyfigures.? Let post your code and requirements in detail.?

SDN can help you.

MSR

[Former Member]

Thanks for the response Srinivas. Here is my requirement:

I have installed the HR PA Cube 0PA_C01 and the infosource etc. Now the user wants 8 keyfigures like Current Hire Tenure(which is current date - Hire Date), Tenure in Current Position (which is current date - start date in current position). Similarly they need 6 more keyfigures which are all based out of date calculations.

I have written the ABAP code to populate these values in Start Routine of Update rules. and it is taking long time to populate them and finish the load.

Could you suggest any other approach. I am thinking of virtual key figures but not quite sure if it will work.

[Former Member]

Hey!!!

Why don't you consider doing the above in report level, of course, it is going to slow down the reporting, you have to loose performance either in front end or data load.

And again, if you are actually just substracting one date from another, I don't see why the performance is slower. Check if there is something else is causing it. I have done a big load with ODS active table lookup and that never reduce performance significantly.

thanks.

Wond