Thanks for those Paul. Three things to add:
1) PAfE has the "Insert Dynamic Report Section" that allows you to add another DR below the existing one i.e. same columns, but different rows. Useful if you have a sheet showing Top N and Bottom N for example.
2) When I create a Dynamic Report, I always end up renaming the named ranges as TM1RPTDATARNG15767888 is meaningless. Yes, you can go to the navigation pane to work with them but find renaming to something like TM1RPTDATARNG_Input and TM1RPTDATARNG_Review calms my OCD.
Would be nice to have a PAfE function to do this rather than manual/macro that I currently use.
3) On some DR's we like to add a checkbox that toggles Suppress Zeroes on and off - the linked cell is referenced in the TM1RPTVIEW. User seem to like having this toggle for their Input sheets or Review sheets.
------------------------------
George Tonkin
------------------------------
Original Message:
Sent: Thu March 25, 2021 01:45 PM
From: paul YOUNG
Subject: Dynamce Reports
I was able to pull some great videos and blog posts from BP. I was looking for input on tips/tricks, best practices, etc. when comes to building dynamic reports including active forms.
https://ibm.box.com/s/epun425cfblfikm06yl767iolqlhaf54
------------------------------
paul YOUNG
------------------------------
#PlanningAnalyticswithWatson