MDX to get current date

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

MDX to get current date

Post by appleglaze28 »

Is there anyway to write an MDX to get the current date element in a month-date dimension?
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: MDX to get current date

Post by Steve Vincent »

doubt there is one directly, but you can do it via attributes & rules.

1> attribute against the elements in the date dim.
2> rule to grab current date, format it the same way as the elements in the dim, then only show a value in the attribute where that matchs the element.
3> MDX to seach for non-blankvalues in the attribute.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply