• The views being what they are, you can only create 1 dimension which holds all the attributes of view 1.

    This is because your fact table (which is view 2) has only 1 surrogate key (the record key) and that key links to a single link in view 1.

    It doesn't link for example to a gender, but instead to the unique combination of name, gender and automobile.

    The dates dimension is created on top of view 2 (I'd rather create a dedicated time dimension, but anyway). The key is the date itself.

    Now, in the data source view you need to link view 2 to view 1 with the record key.

    The measure group is created on top of view 2 and selects only the measures.

    This measure group is linked to the dimension of view 1 (in the dimension usage tab) using the record key.

    If you want seperate dimensions, you'll need to create views on top of view 1 and assign surrogate keys. It's a bit of a mess this database unfortunately.

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