Planning Analytics

 View Only
  • 1.  Dynamce Reports

    Posted Thu March 25, 2021 01:45 PM
    Edited by System Fri January 20, 2023 04:46 PM
    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


  • 2.  RE: Dynamce Reports

    IBM Champion
    Posted Fri March 26, 2021 04:51 AM

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