Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I stumbled upon the following issue in SQL Server Analysis Services (SSAS) When processing a Cube database.

I have a dimension that has sub dimensions, however if the parent record refers to a child that is not there anymore (null) the parent is being discarded and not inserted into the Cube.

How can I make it so the parent record isn't discarded?

In my case we are talking about 5 to 6 million records.

share|improve this question
Need more information if I'm going to be able to help you there chief. What doe these dim tables look like schema wise for starters? – Zane Oct 11 '12 at 21:12

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.