it turned out the answer to my problem was configuring the NULL processing in the dimension usage panel in the cube. i had configured the dimension to use an Unknown...

it turned out the answer to my problem was configuring the NULL processing in the dimension usage panel in the cube. i had configured the dimension to use an Unknown...

Hi,

I'm currently seeing a similar error but it's being caused by NULL dimension keys on the fact record being converted to 0 when the cube is processed.

I have the dimension...

not sure if this will be the answer to your question but i've just had a similar problem. essentially, i had heavily fragmented secondary non clustered indexes... use dbcc showcontig...