MDX to get current date
-
- 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
Is there anyway to write an MDX to get the current date element in a month-date dimension?
- 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
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.
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
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet