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

Tagged: , ,

  • Now and Format in MDX

     George updated 3 weeks, 3 days ago 3 Members · 4 Posts
  • Vitalij

    Member
    1-May-21 at 12:07 am
    0 Diamonds
    2 Gold
    270 Experience
    Scout

    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

  • John

    Administrator
    1-May-21 at 7:34 am
    2 Diamonds
    14 Gold
    1,530 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
      270 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
    0 Gold
    50 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

Viewing 1 - 3 of 3 replies

Original Post
0 of 0 posts June 2018
Now