Planning Analytics

 View Only
  • 1.  Update PAX Published Custom Report in PAW

    Posted Wed June 26, 2019 08:41 AM
    I have recently published a PAX Custom Report into PAW with a date dimension (May YTD, etc) that I would like to be able to toggle and change in the web and not have to go back in to PAX and update/republish each month. Is there any way of doing this? Currently when I change from May YTD to Jun YTD in the web the numbers refresh but as soon as I exit PAW and go back in it reverts to the May YTD that was initially published in PAX.

    ------------------------------
    Mick Ferguson
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Update PAX Published Custom Report in PAW

    Posted Wed June 26, 2019 12:49 PM
    The only way I have found to dynamically change content of published report, is to have the title you want to toggle point a utility cube that contains the value you want to change.   In this method the change is a value in cube when you make the change TM1 retain the value and it will dynamically change any report that that references the cell in the utility cube.    Of course you can surface the one intersection of the Utility cube in PAW so it can be changed from PAW.

    ------------------------------
    Nick Rueda
    ------------------------------



  • 3.  RE: Update PAX Published Custom Report in PAW

    Posted Thu June 27, 2019 02:12 AM
    I suggest you use both a cube to store "current reporting period" and a subnm in the report that leverages an mdx subset that looks up that value. That way you get
    1. A standard starting point
    2. Access to synchronization
    3. Easy to change it for users


    ------------------------------
    Ryan Clapp
    ------------------------------



  • 4.  RE: Update PAX Published Custom Report in PAW

    Posted Thu June 27, 2019 04:11 PM
    Thank you both for the feedback it was very useful. We have implemented as you suggested and it worked like a charm, thanks again, much appreciated!

    ------------------------------
    Mick Ferguson
    ------------------------------