left join on date dimension

Comments

3 comments

  • Avatar
    Nathan Giusti

    Hi Lisa, 

    I'm not sure what you are trying to accomplish. If you want all dates, including dates without orders, I would just open up an excel file, and write in all the dates you need. You can write one date and drag. 

    We also have some prebuilt date files here https://support.sisense.com/hc/en-us/articles/230646508-Calculating-Business-Days-Difference-Between-Two-Dates

     

    If this isn't what you are looking for, maybe you describe more closely what you'd like the output to be. 

    0
    Comment actions Permalink
  • Avatar
    Lisa Jay

    Hi

    The issue I have is dates missing when there are no orders.

    Because I have different dates across the facts when I have used the date file previously  I have had issues with calculations therefore I created a distinct date dimension from the fact tables.

     

    I can try creating a test elasticube and use the date file as suggested and see if this works.


    Lisa

    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Hi Lisa,

    I may be wrong, but it looks like you will have to change your fact table into a custom sql table that will do a union between original fact table and rows you will add so that the fact table contains at least a row for each date.

    Best, David

    0
    Comment actions Permalink

Please sign in to leave a comment.