Why does NOW member not work properly in MDX Query Tool?
In the MDX Query Tool I can't seem to get the NOW relative syntax to work correctly. If I just use ".&[NOW]" it works, but something like ".&[NOW-1]" or ".&[NOW-1d]" (for dates extracted using DayMonthYear) it throws an error.
So this works:
But if I change .&[NOW] to .&[NOW-1] I get this cryptic error message.
Also, can you use member functions off of NOW? For example can you do something like: [TransactionDateFilter].[H1].[Date].&[NOW].PREVMEMBER ???
Product version: IRIS 2020.1