Cannot find a dimension from associated dimension table.


  • Hi,

    I have a dimension issue that I need help to resolve.

    I have the following tables:

    Scenario #1

    I want to group F_Contract based on ActivatedDate (in F_Contract). This is simple because I have a direct connection from ActivatedDate to D_date (this creates a ActivatedDate-dimension)

    Scenario #2

    I want to group F_Case based on ActivatedDate (in F_Contract).
    Here is my problem: I start of by counting F_Case but since ActivatedDate is a member of F_Contract I can't get to it.
    Off course, I could be using D_contract to get to ActivatedDate, but I still miss the ActivatedDate-dimension from F_Contract...

    It would be nice to be able to use the exisiting ActivatedDate-dimension from F_Contract...
    Hope someone out there can help me?


    Marius H Enerud

    Tuesday, November 12, 2013 12:10 PM

All replies