Parallel Loading of Cube

[former_member213594]

Hi All,

Before we have one ODS for all company codes and one cube for reporting.

Due to some performance problems we created the regional ODS for each company code by keeping the same consolidated cube at top.

Is there any possibility of table locks at Consolidated Cube if its populates from all regional ODS at a single time , if so how can i keep them in sequence.

The Regional ODS were designed with automatic update option and we have one upload per day.

Could you please kindly some experts have some valuable inputs on this design.

Thanks & Regards

Martin Leo

[former_member213594]

Hi Ron , SR,

Thanks very much for experienced inputs.

This Consolidated cube already having the data Since Jan 2004 to July 2004 and we created Regional ODS to update this cube from August to December 2004.

It could be possible for Regional Cubes to feed the data from related Regioanl ODS in next year.

Thanks on the same.

Kind Regards

Martin Mouli

[Former Member]

There should be no locking issues in laoding multiple infopackages into one infocube. IF you are using Oracle, be aware that a new partition is generated for each InfoPackage load, and that the only way to manage the number of partitions is through InfoCube compression.

If you have been able to segment your ODS by company code, perhaps you should consider making the "Consolidated Cube" a MultiProvider, consisting of seperate base cubes that each hold one company code's data. That way you have a global view with good performance advantages (parallel processing, sub-queries read smaller tables, etc).

[Former Member]

Ron,

Thank you for your expert opinion.

Reddy

[former_member213594]

Hi SR,

Thanks for valuable inputs.

We are using one info package to pull the data from R3 and distributing the data into several Regional ODS in start routine.

As per my assumption there is no Fact Table lock ( Les number of records ODS activate first and updates the cube)

But if there is 5 percent scope for table lock , we are in big trouble where our reports were palced in Portals.

Kind Regards

Martin Mouli

[Former Member]

Hi Martin,

I have never heard of fact table locks. There is the Master data table being locked but never experienced or heard a fact table being locked. So you should be fine. and as you said less number of records ODS will go first.

Try this once and if it doesnt work, I will think about a suitable process chain for you.

SR

[Former Member]

I dont think simultaneous loads from all ODSs is going to lock up the fact table.

However I do suggest that having them load sequentially is a better option because when you load it a same time, you will trigger of a lot of background processes which can time each other out.

Why dont you put these ODS loads in a sequence in a process chain to execute one after another??

Lets hear some other opinions from experts

SR