Planning Analytics

 View Only

  • 1.  Add Canvas Values in IBM PAW

    Posted Thu April 25, 2019 11:33 AM
    Edited by System Test Fri January 20, 2023 04:27 PM
    Reply
    Hi,
    In PAW we have built a Dashboard  using Product on Rows , Years on Columns for  Sales Measure.
    Other dimension we used as Widgets to filter the Data. 
    In below image , we have  two issues .
    1. I added total AM , Market and Sales Values as " Add Canvas " Values. When we close the book and re-open Market and Sales Values are disappearing,I tried adding couple of times and saved and re-opened , issue remained same.

    2. Is there any way to change the Add Canvas Values Dynamically whenever user drill down the hierarchy?.

    Ex : At present , 1.4 B is the total product value for the particular year , region and Currency. When I Drill-Down the Product Dimension from BU-Endoscopy to SBU Endoscopy " Add Canvas " value should be changed from 1.4 B to SBU -Endoscopy total 10.35 M ( 1035073490 ). Its not happening now. 
    Any suggestion please or is it product functionality limitation?
    Add Canvas Values are not showing when we close and open the Book.


    Thanks ,
    ------------------------------
    Srinivas
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: Add Canvas Values in IBM PAW

    Posted Wed May 01, 2019 08:49 AM
    Reply
    Hi Srinivas,

    Will attempt to address both your questions here:

    1. Both metrics (i.e.: "Market" & "Sales") should have values appearing. Since you have activated filters, I'd recommend the following options;
      • Single-click on the filter for each canvas widget to see what combinations its currently fetching data for. Chances are that the combinations are off. 
      • Data may have been reduced to "zero" for the selected combinations. So merely repopulate info.
      • Redo the "Add to sheet" activity for the cells which contain data for "Market" as well as "Sales".
    2. All widgets by default do not sync with the dimension element selector widget. To do that you can follow the below steps;
      • Single-click on the widget you wish to synchronise with the dimension element selector widget.
      • Click on the "Properties" button on the top-right of your sheet within the book.
      • Click on "Synchronize" within the "Cell View Properties" menu.
      • Activate "Synchronize dimensions".
      • This should ensure sync between dimension element selector widgets & your canvas cell widgets.
    Do let me know if it works!

    Cheers.


    ------------------------------
    Roscoe Lobo
    ------------------------------

    Original Message