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

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