Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  Change Member Display in a Quick Report

    Posted Tue November 21, 2023 04:45 PM

    In Planning Analytics for Excel (PAfE), is it possible to build a quick report using member_ids, but display the data with the alias

    This would prevent the quick report from breaking due to an alias change, but still enable users to see the intutive alias.



    ------------------------------
    Katya Gilbo
    ------------------------------


  • 2.  RE: Change Member Display in a Quick Report
    Best Answer

    Posted Wed November 22, 2023 06:45 AM

    Hi Katya,

    You can do it with formulas, much the same way you would do it in "old" reports.

    Create your quick report using member ID, insert a column left or right of that and use a DBRA formula to get the alias. Hide the column column with the member id's.



    ------------------------------
    Emil Malmberg Fosdal
    Solution Architect
    CogniTech A/S
    ------------------------------



  • 3.  RE: Change Member Display in a Quick Report

    Posted Mon November 27, 2023 01:04 PM

    Super helpful, thanks!



    ------------------------------
    Katya Gilbo
    ------------------------------