Missing Dimension members

I have a cube which used to throw an error when processing. This was because the fact table had rows which had empty values.And there was no corresponding row in the dimension tables having an empty values.

What I did was introduce a default row in all the dimension tables.

As a result the cube got processed without any error. But the problem arose with the members in the date dimensions. 开发者_如何学CSome of the members were just missing when the cube was re processed.

I tried looking into the fact table but the data seems fine. If the queries for the dimension tables are run seperately, all the members are present.

---

This issue got solved. What i did was reload the database and then process the cube again. Surprisingly all the members are now visible.