Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
2 years ago

How to setup a composite model

Had a directquery source and could not figure out how to make it mixed/composite

 

So I started new with an autocalendar, then added a direct query.

This apparently got me a mixed mode.

 

But why can I not make this relation??

 

The directquery has a date field and I thought to easily connected my date table with my directquery source.

 

What is going wrong? (yes I can it says circular dependency 😉 )

 

Need Help

4 Replies

  • rpinxt's avatar
    rpinxt
    Solution Sage
    2 years ago

    zenisekd 

    It is setup from and CALENDARAUTO() :
    dimDate =
    ADDCOLUMNS(
    CALENDARAUTO(),
    "Year", YEAR([Date]),
    "Quarter", FORMAT([Date],"\QQ"),
    "Quarter Nr", QUARTER([Date]),

    etc.

  • rpinxt's avatar
    rpinxt
    Solution Sage
    2 years ago

    Well how about this....

    This works....but the other way around i get that circular dependency....🤔

     

  • rpinxt's avatar
    rpinxt
    Solution Sage
    2 years ago

    Ok so now the connection is there but it seems not to be working:

    The yellow marks are different than normal.

     

    I wanted to show the Quantity by period :

    Nothing.

    Quantity is the field Actual Qantity Delivered in the direct query source.

    And period comes from the autocalendar en is setup like this :

    dimDate =
    ADDCOLUMNS(
    CALENDARAUTO(),
    "Period", FORMAT([Date], "MM-YYYY")

    )

     

    Is this just not possible with direct query or am I doing something still wrong??