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

Base Camp Base Camp Forums General Questions Now and Format in MDX

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:

    https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-315

    Thank you in advance.
    With best regards,
    Vitalij

    George replied 8 months ago 3 Members · 3 Replies
  • 3 Replies
  • John

    Administrator
    1-May-21 at 7:34 am
    2 Diamonds
    14 Gold
    1,850 Experience
    Hiker

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

    • Vitalij

      Member
      3-May-21 at 6:51 pm
      0 Diamonds
      2 Gold
      300 Experience
      Scout

      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

  • George

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

    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