The problem with including date or week attributes in your Microstrategy cube when calculating N-1 values is that it will not accurately represent the previous period's data. This is because dates or weeks have a changing set of days every year, so comparing the same number of days between periods may not give an accurate representation of the data. It is recommended to use N-1 day or N-1 month calculations for accurate comparisons.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2021-12-15 11:00:00 +0000
Seen: 8 times
Last updated: May 28 '22