Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  MDX generator based on Cube value

    Posted Thu February 09, 2023 09:27 AM

    Hi Community, 

    I have a question about the MDX. 

    I usually use this MDX Expression window to create some MDX (then i add more code like Except, Join to get that i want)

    But i can only generator the MDX to filtre by attribut or level. 
    Sometime, i need to make the MDX to filtre based on cube value. 
    For exemple : get top 10 element that have highest volumes in cube PL

    { TOPCOUNT( {FILTER( {TM1SUBSETALL( [ACTIVITE_REPORTING] )}, [ACTIVITE_REPORTING].[FERME] = "PAYS_REPORTING_CHARGE_PAYS")}, 100, [CHARGE_REPORTING_1].([VERSION_PLAN_CHARGE].[2019-FEV-PC-.V1-2019_02],[TYPE_MO].[INGENIEUR],[SECTION_METIER].[408400_DP],[EXERCICE_COMPTABLE].[2019],[M_CHARGE_REPORTING_1].[GW]) )}

    Or get all element that have Check value in cube PARAM between 0 and 5

    I still can make the MDX when i need but iam wondering if there are a way to do it easier? (something that create automatique MDX code that i need)

    Some MDX that i need usually : top10, value between A and B, all except the value XXX....

    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
    ------------------------------


  • 2.  RE: MDX generator based on Cube value

    Posted Thu February 09, 2023 03:52 PM

    Hi @Duong DAU , have you looked into Tools > Filter?

    It doesn't do everything you listed, but can give you some basics to start with

    BTW very cool ideas and it would be great to see this implemented in IBM PA!!!

    Certainly I will be adding this functionality to TeamOne GS add-on and MDX mods 



    ------------------------------
    Vlad Didenko
    Founder at Succeedium
    TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
    https://succeedium.com/teamone/
    ------------------------------

    Original Message