Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Why does NOW member not work properly in MDX Query Tool?

Question
Lee Cascio · Jan 4, 2021

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 ???

#InterSystems IRIS BI (DeepSee)
Product version: IRIS 2020.1

Source URL:https://community.intersystems.com/post/why-does-now-member-not-work-properly-mdx-query-tool