After processing dimension some of the attribute members are missing even I know they were read
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.
Day MonthKey MonthName2007-01-01 200701 January2007-01-02 200701 January2007-01-03 200701 Jaaanuary