Planning Analytics

 View Only
  • 1.  MDX Filtrebypattern on alias

    IBM Champion
    Posted Wed December 21, 2022 12:03 PM
    Hi everyone, 

    I'am looking a way to make a MDX Filtrebypattern work on alias

    For now, i can make a MDXFiltrebypattern work on code element 

    Exemple : {TM1FILTERBYPATTERN( {TM1SUBSETALL( [RH_Matricule] )}, "*10*")} ==> looking for all element who contains 10 in code of element. 

    But i want to make a MDXFiltrebypattern  that work on alias of element. (i know if i active the alias, it will work on architect, but i need a MDX filtre)
    Exemple : Looking for all element who contains "Elise" in "Alias" of element

    Can someone give me an idea? 

    Any help will be appreciated!
    Thanks!

    ------------------------------
    Duong DAU
    Consultant EPM Finance Transformation & Performance - Micropole


    M +33 (0)7 62 61 85 33
    F +33 (0) 4 26 99 60 81
    131 Boulevard Stalingrad / 69100 Villeurbanne
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: MDX Filtrebypattern on alias

    IBM Champion
    Posted Wed December 21, 2022 12:16 PM
    Hi Duong,

    There is a 3rd parameter where you can specify the alias or attribute to be searched.

    Check out the documentation online as it was recently updated.

    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=tsmf-tm1filterbypattern-set-pattern-str-attribute-1

    ------------------------------
    George Tonkin
    Business Partner
    MCI Consultants
    Johannesburg
    ------------------------------



  • 3.  RE: MDX Filtrebypattern on alias

    IBM Champion
    Posted Wed December 21, 2022 01:20 PM
    Thanks a lot !!!
    It work very well !​

    ------------------------------
    Duong DAU
    Consultant EPM Finance Transformation & Performance - Micropole


    M +33 (0)7 62 61 85 33
    F +33 (0) 4 26 99 60 81
    131 Boulevard Stalingrad / 69100 Villeurbanne
    ------------------------------