problem processing ........

[alandool]

Hi All,

I'm trying to process a cube. The fact table has around 13.6 million records, and there are 5 dimensional tables. Nothing out of the ordinary. All the dimensional tables process, but once it gets to creating the partition it hangs up and eventually fails.

I've had no problems w/ smaller fact tables, etc. Any suggestions?

alandool

 

[MDXer]

what is the message when it fails?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[alandool]

Hi MDXer,

When trying to process this cube, it eventually fails and says that the "connection was lost."

However, in a effort to understand where the problem was I recreated the cube adding each dimensional table (5 in total), one at at time, and then attempted to process after each step ... stopping it once I seen it was okay with each step. That worked fine, it would process the cube as I added each dimensional table .... until I added the fifth dimensional table. The fifth table contains only one field with 5 possible values. The cube would not process once this table was added .... eventually I received the "connection was lost" error and it just rolled everything back. So, I removed the fifth table from the cube and ........ the cube will process. Strange. The dimensional table will process by itself though.

Any ideas / suggestions?

alandool

 

[MDXer]

whats the structure for the dim? is it an independent table or are you trying to derive this dimension from a column in your fact or another larger table?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[alandool]

It's an independent table.

 

[MDXer]

Are you able to optimize the cube? When you process the cube you will see the SQL code being issued to the server you can view this code and see if it is doing anything that you don't expect it to be doing. also make sure that the dim table is joined to your fact table properly.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck