Forum Discussion

computermike's avatar
computermike
Icon for Helper I rankHelper I
9 years ago
Solved

Any issue for a Date Dimension without day?

I have some data but it is aggregated at the Month level.  Would I have any issues created a Date table with the following columns  DateID(int), Date(date).. but only for the first i.e. 1/1/2017, 2/1...
Need Help
  • computermike's avatar
    computermike
    Icon for Helper I rankHelper I
    9 years ago

    Yes, I was hoping to use time intelligence.  I guess I will create a table with all dates.  I thought I might be able to save space by skipping individual days.  Not advanced enough to write my own time intelligence functions.

     

    I also decided I will not need some columns.  My new schema will be...    Date(date) i.e. 1/1/2017, 1/2/2017,     Month(string) i.e. "Jan", "Feb",    Year(number) i.e. 2016,2017.  I will be using Month and Year as Labels on my report.  Thought about making Year a string too, but don't think it ios that big of deal.  I will sort Month using Date.

     

    Thanks,

     

    Mike

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      9 years ago
      computermike wrote:

      Yes, I was hoping to use time intelligence. 

      You can still use time intelligence with a non-day level calendar, just not the inbuilt time intelligence. Custom time intelligence is easy once you learn how. Read my article on the topic posted earlier. I explain how it works and you can go from there. If you can put a filter in a table using the drop down arrows to filter the table to show the dates you need, then you can write custom time intelligence.
      I guess I will create a table with all dates.  I thought I might be able to save space by skipping individual days. 
      The space saving on a dimension table would be insignificant.