Performance Tuning for HR Cubes

[Former Member]

Hi All,

Anybody has experienced in 0PAOS_C01 performance (update rules) !! ... please advise me ...

TQ

BR

Kumar

[edwin_harpino]

hi Kumar,

take a look oss note 567747 'Composite note BW 3.x performance: Extraction & loading' (note 184905 if you are in bw 2.x).

also check if oss note 604128 relevant.

some bw data loading performance docs links.

hope this helps.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/1955ba90-0201-0010-d3aa-8b2...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ce7fb368-0601-0010-64ba-fad...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/2299d290-0201-0010-1a8e-880...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/afbad390-0201-0010-daa4-9ef...

oss note 604128

Symptom

Long runtimes occur when you update 0HR_PA_0 and 0HR_PA_1 InfoSources into InfoCube 0PA_C01 or 0HR_PA_OS_1 InfoSource into InfoCube 0PAOS_C01.

Other terms

InfoSource, update rules, routine, 0EMPLOYEE, 0PERSON, 0HRPOSITION, master data, attributes

Solution

Performance-enhancing corrections, which could reduce the runtime by approximately 10%, have been made in includes RS_BCT_HR_PAPA_UPDATE_RULES and RS_BCT_HR_PAOS_UPDATE_RULES, which are used in the delivered update rules of InfoCubes 0PA_C01 and 0PAOS_C01.

[Former Member]

Ranj,

In performance tuning I have an excellent document, just put a mail to ramup@lancoglobal.com

Please mention performace tuning in the subject line.

Thanks

Ramu

[Former Member]

Hi Nathan,

Performance is a critical issue in developing a data warehouse because of the size of data in the system.The following link will take you through various performing tuning issues like BW statistics,System administration assistant,Tuning query performance and load performance.

http://safari.oreilly.com/JVXSL.asp?x=1&mode=section&sortKey=title&sortOrder=asc&view=&xmlid=0-201-7...

Awarding points is the way to say thanks in SDN!!!

Regards,

Balaji