• Since you have 1 fact for each issue (I guess the only measure is a count?), it is possible to have a 1 to 1 relationship.

    Personally I would store status and priority in dimensions. Text attributes do not really belong in a fact table.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP