MDX to get current date
Posted: Fri Nov 12, 2010 2:53 am
Is there anyway to write an MDX to get the current date element in a month-date dimension?
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.