Wednesday, February 15, 2012

Empty cube after date dimension added

In 2000, we could tell immediately whether there was data in the cube by running the SQL Statement that was used to process it. We could also troubleshoot join issues between dimension tables. In 2005 the process has changed. The cube update appears to be independent of the dimension update.

When I add a custom date dimension to my cube, all data within the cube disappears. My measures are empty, and I cannot get data back no matter what I slice and dice.

The SQL Statement used to process the cube returns records, however the cube browser is empty.

Has anyone else experienced this? How can we troubleshoot what data shows up in the cube, and if there is any data present?

Still looking for an answer on an easy way to troubleshoot missing data in the cube and relationships between dimensions & measure groups.

To resolve the problem above, I created a new dimension, and did not set it to a time dimension.

No comments:

Post a Comment