Ask Your Question
1

What is the problem with my metrics that calculate N-1 values when I include date or week attributes in my Microstrategy cube?

asked 2021-12-15 11:00:00 +0000

lalupa gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2022-05-28 14:00:00 +0000

bukephalos gravatar image

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.

edit flag offensive delete link more

Your Answer

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

Add Answer


Question Tools

Stats

Asked: 2021-12-15 11:00:00 +0000

Seen: 8 times

Last updated: May 28 '22