Skip to Content
0
Former Member
Jun 03, 2010 at 02:53 PM

Process dimension with 100 000 elements

10 Views

Hi guys,

I am currenty trying to develop a package for master data flow for BPC. Members for some dimensions arrive from other external systems.

The problem is that one dimension exceeds 100 000 members.

The question is how to process this dimension?

From Admin Console it takes some 5-6 hours and it seems to be able to process the dimension if I don't select FULL PROCESS.

From my SSIS package the task Make_Dimension with option ApplicationProcess = 0 takes 6 hours and fails. It gives some kind of timeout error.

Are there any considerations on how to make successful process of a dimension with 100 000 members from SSIS?

Thanks.

Best regards,

Valeriy Shylin