-
Now and Format in MDX
Hello guys,
Do you know if it is possible to use the function Now directly in MDX?
I found an entry at the IBM-Webpage from last year that it was asked for it, however, as to Stuart King it has not been yet at the list for this year roadmap.Maybe you are also interested in such a function and would like to vote for this:
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-315
Thank you in advance.
With best regards,
Vitalij -
3 Replies
-
That would be useful, wouldn’t it. I have voted for it, but as Stuart says, it’s not on the roadmap.
-
Hello John,
thank you for your vote!
Let us see if we get many votes, so that maybe IBM gets this point on their roadmap 😉 !
With best regards,
Vitalij
-
-
Better late than never…
If you have a control or assumptions cube in your model you could rule derive today or yesterday as required into the cube.
You could then have MDX that uses that value. The following code will return the member from my Period dimension based on my control cube where Today is the current period/month:
{StrToMember(“[Period].[Period].[” + [Control].([Control Measures].[Today],[Control Measures].[Value]) +”]”)}
HTH
