Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  How to enforce Alias usage in a MDX Subset query

    Posted Wed March 31, 2021 07:52 AM
    Hello Community,
    I was wondering how I can enforce an Alias usage for a dynamic subset ? I know that once you've created the MDX Dynamic Subset you can click on the Alias button and save it again but my concern is that during the dimension update, we usually destroy and recreate all the attributes to avoid any kind of errors and so when I get back to the dynamic subsets, the alias are no more checked.
    Regards,

    ------------------------------
    Bob
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: How to enforce Alias usage in a MDX Subset query

    Posted Wed March 31, 2021 08:01 AM

    You can always add SubsetAliasSet in the Epilog of TI that updates the dimension, so that way its always updated with TI execution.

     

    R,

    Amin Mohammed

    Practice Lead

    Octane Software Solutions

    p: (02) 8883 1350  

    m: +91 7032 7476 73

    a: Level 1, 100 Clarence Street, Sydney NSW Australia

    1507521120072_logo

          

     

     




    Original Message


  • 3.  RE: How to enforce Alias usage in a MDX Subset query

    Posted Wed March 31, 2021 08:07 AM
    Hello,
    Thanks for your quick answer and indeed that was @frédéric Mallaval ​advice. We put that in place this morning but I was wondering how it can't be accessible from the MDX statement itself.
    Regards,

    ------------------------------
    Bob
    ------------------------------

    Original Message


  • 4.  RE: How to enforce Alias usage in a MDX Subset query

    Posted Wed March 31, 2021 08:16 AM

    AFAIK, it is not possible to activate alias as a part of mdx expression.

     

    Amin Mohammed

    Practice Lead

    Octane Software Solutions

    p: (02) 8883 1350  

    m: +91 7032 7476 73

    a: Level 1, 100 Clarence Street, Sydney NSW Australia

    1507521120072_logo

          

     

     




    Original Message


  • 5.  RE: How to enforce Alias usage in a MDX Subset query

    Posted Wed March 31, 2021 08:26 AM

    Also, alternatively, since you're deleting all the attributes and recreating it, can I suggest using CubeClearData of your attribute cube as opposed to attribute deletion as that is breaking your mdx subset? Just thinking aloud..:)

     

    Amin Mohammed

    Practice Lead

    Octane Software Solutions

    p: (02) 8883 1350  

    m: +91 7032 7476 73

    a: Level 1, 100 Clarence Street, Sydney NSW Australia

    1507521120072_logo

          

     

     




    Original Message


  • 6.  RE: How to enforce Alias usage in a MDX Subset query

    Posted Wed March 31, 2021 08:32 AM
    Hello,
    Clearing the attribute cube isn't a hundred percent guarantee to avoid attributes potential errors during the dimension update, that's why we stick to our delete/recreate stuff ;-)
    Regards,​

    ------------------------------
    Bob
    ------------------------------

    Original Message