In retail analytics, it is very frequent to require comparisons between previous/current year, month and so on. There currently is no support for this kind of analysis in ad hoc. It could be done using OLAP, but as that may not be available indefinitely, replacing OLAP would absolutely require this kind of functionality.
Roland Wammers
| Components | AdHoc |
Thank you for this idea. We will consider taking it up.
I guess that would be the cherry on the cake, but for now being able to do this (generically speaking) for column-over-column type use cases (regardless of how the columns are defined) would be enough already.
I assume they need to do these off a specific fiscal calendar...