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
------------------------------
Original Message:
Sent: Thu June 27, 2019 02:12 AM
From: Ryan Clapp
Subject: Update PAX Published Custom Report in PAW
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
- A standard starting point
- Access to synchronization
- Easy to change it for users
------------------------------
Ryan Clapp
Original Message:
Sent: Wed June 26, 2019 12:46 PM
From: Nick Rueda
Subject: Update PAX Published Custom Report in PAW
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
Original Message:
Sent: Tue June 25, 2019 07:02 PM
From: Mick Ferguson
Subject: Update PAX Published Custom Report in PAW
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