Forum Discussion
skondolf
8 years agoRegular Visitor
Time Intelligence with Monthly Data Model
Hello - BI Newbie here and probably something very simple but I can't find a definitive answer so my apologies in advance ... I'm working on my first BI project and have a requirement to prov...
- 8 years ago
Sounds like the right approach.
- 8 years ago
Agree, I routinely create models with monthly transactional data, and simply follow a first-of-the-month or last-of-the-month date convention with dates in the fact table (can't see any reason to prefer one over the other), related to a standard daily calendar table.
As long as reports don't filter below the month level, it works just fine with time intelligence functions.
There are methods to allocate monthly data to days (some ideas e.g. here) but there is no point in doing this if your underlying granularity is monthly.
Seward12533
8 years agoSolution Sage
Sounds like the right approach.