Post reply

Fact/Dimension problem

  • September 16, 2015 at 11:03 am

    #147528

    I'm new to SSAS and I'm stuck on something I would like help with. I have a cube which consists of a fact table and about 12 dimensions. When I browse the cube and reference attributes in many of the dimensions, I get the expected results. But there is at least one dimension that doesn't seem to be working right. When I'm browsing the cube and select an attribute from this dimension, it ends up displaying all the records in the dimension table even when many of the dimension key values don't match the fact table record key value.

    For example, assume Employee_id on a Fact table is joined to the Employee_id on the dimension table, which also contains respective employee first and last name fields. And assume (for simplicity), that the Fact table has records where the Employee_id is either 1, 2 or 3. But assume the dimension table has records where the employee_id ranges from 1 - 1000. I would tend to think when browsing the cube and viewing the measures from the Fact table and the employee names from the dimension table, that the only dimension record values to appear would be for employees with ID 1, 2 or 3. But in my situation, browsing the cube displays the employee first and last names for all 1000 ids.

    Note that I examined the cube and verified the fact and dimension table seemed to be joined correctly on the key.

    I hope this makes sense!

    Thanks in advance for any help you can provide

  • September 16, 2015 at 11:15 am

    #1827154

    If you see the same measure value for all of the employees in your list, the most likely problem is that you do not have the relationship defined in the "dimension usage" tab of your cube's design.

    Defining the relationship in the data source view is not the only requirement, you also have to ensure that it is defined in the "dimension usage" tab for each cube.

    Hope this helps.

  • September 16, 2015 at 12:38 pm

    #1827177

    Thanks so much for your help! I checked out the Dimension Usage tab and it seems the relationship between the problem dimension and fact table got corrupted or was never set properly. I dropped the dimension from the datasource, readded it with the correct relationship and processed the cube. It seems to be working now!

    Thank you!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply