Find answers, ask questions, and connect with our
community around the world.

Tagged: , ,

  • Now and Format in MDX

    Posted by Vitalij on 1-May-21 at 12:07 am

    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:

    Thank you in advance.
    With best regards,

    George replied 2 years, 8 months ago 3 Members · 3 Replies
  • 3 Replies
  • John

    1-May-21 at 7:34 am
    2 Diamonds
    14 Gold
    2,210 Experience

    That would be useful, wouldn’t it. I have voted for it, but as Stuart says, it’s not on the roadmap.

    • Vitalij

      3-May-21 at 6:51 pm
      0 Diamonds
      2 Gold
      320 Experience

      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,

  • George

    6-Nov-21 at 7:50 pm
    0 Diamonds
    3 Gold
    130 Experience

    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]) +”]”)}


Log in to reply.