After processing dimension some of the attribute members are missing even I know they were read

Written by Vidas Matelis. Posted in Design FAQ

Q: After processing dimension some of the attribute members are missing even I know they were read by SSAS.

A: There are few reasons why you think that SSAS does not load all attribute members after processing. First you have to make sure that members are not dropped during the load into SSAS. Example, if you have inner joins to other tables, it could be case that inner joins fillters our some members. Test query that is submitted by SSAS to source DB. If you are sure that SSAS is reading members, but they do not appear, then check if some of the member keys are duplicates. Duplicate keys will make just one record to appear in SSAS dimension member list.

It is quite seldom that dimension key attribute will have this problem, as in most designs key attribute is primary key on the table. But for regular attribute this can happen quite often.

Example

Day                 MonthKey    MonthName
2007-01-01    200701        January
2007-01-02    200701        January
2007-01-03    200701        Jaaanuary

If you load above example data into date dimension, you will endup just January or(!) Jaanuary member for key 200701
---------------------------

Tags: design, faq, process