• Hi Paul Thanks For the reply,

    If you can provide some more information on this, It will help me to understand better.

    1. will degenerate dimension contain only one attribute ?

    as u mentioned in ur example ( check number attribute)

    2. I have created cube(SSAS 2012), while creating it, it prompts me to create a dimension based on my fact table . can we say this as degenerate dimension which I mentioned as requirement in my above post.

    3. what could be the dimension key for this degenerate dimension ?

    Is that check number attribute or some other fact key?

    Thanks & Regards,

    NIHARIKA