10/16/2012

Troubleshoot the Tabular Model Today

So I was looking at the new Tabular Model today and something didn't seem right.

For some reason the cube had 20 million rows, when the source table had 13 million rows.

With the help of the senior architect, we removed all the dimensions.

Surely that would produce the correct number.

Nope.

Hmmm.

So I began to investigate.

And there is was, in the Partition for year 2011.  I accidently put <= 2011 instead of = 2011.

Thus, extra rows.

So I'm re-running the job now, with the Dimensions added back in.

I'd bet a quarter of a dollar it works this time.

Except I don't gamble.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder