Planning Analytics

 View Only
  • 1.  PAW Exploration - Magic update

    IBM Champion
    Posted Tue March 16, 2021 12:59 AM
    I recently had to rebuild a few cubes to include some additional dimension to cater to changed business needs.

    One set of tasks on my list was to go into all my PAW books and recreate the explorations to take into account the new dimensions.

    To my surprise, the explorations were not broken and returned data.  The new dimensions were hidden as default dimensions and could be added back to the context area.

    Having the exploration magically pick up the new dimensions and render the view as before save quite a lot of time.

    Thought I would share this feature in case anyone else needs to do the same in the future.

    Thanks IBM for making this seamless and stress free!

    p.s. For those who never worked in Architect, you need to recreate all your views from scratch, meaning assigning the correct dimensions to context, rows, columns then setting the subsets and relevant members.  If you have many views, you are in for some work. Yes you can edit the .vue file but still takes more time than PAW.

    ------------------------------
    George Tonkin
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAW Exploration - Magic update

    IBM Champion
    Posted Wed March 17, 2021 03:28 AM
    Hi George
    I totally agree with you. I was very pleased to have the same experience as you when I had to make similar changes.
    Thanks for sharing.

    ------------------------------
    Jesper Poulsen
    ------------------------------



  • 3.  RE: PAW Exploration - Magic update

    IBM Champion
    Posted Wed March 17, 2021 03:42 AM
    Edited by System Fri January 20, 2023 04:15 PM
    I have noticed quite a few "Unable to refresh contents of widget. VIEW_CONVERSION_FAILED" errors as I am updating.
    Looks to happen more often than not if I was in edit mode on the previous tab then go to the next and the exploration is blank.

    I simply ignore this now and go back to the previous tab then forward again and click Refresh.
    The "meatballs" menu on the right (Other dimensions) does not show the extra dimensions available at this point but saving, closing and reopening the book fixes that. Even hiding a dimension to put it into the Other dimensions does not allow you to access the contents of Other and Default dimensions.

    Seems reproducible now so will probably log an issue on this.

    Hope this helps anyone having similar issues.

    ------------------------------
    George Tonkin
    ------------------------------



  • 4.  RE: PAW Exploration - Magic update

    IBM Champion
    Posted Wed March 17, 2021 11:16 AM
    Have logged with IBM support now as I can replicate with a simple 2D cube on PAW 2.0.61

    I just created a New book - two tabs, created an exploration from the same cube on both.

    On Tab 1 I had Period on Rows and Measures on columns. Tab 2 these were switched.
    I save the book and closed.
    I open the book to Tab 1, clicked on edit mode then clicked Tab 2 - Blank exploration!

    Could not refresh Tab 2 - got an Unable to fetch data and then an unable to refresh widget.

    If I close and re-open, do not go into Edit mode, I can see contents on Tab 1 and Tab 2 perfectly.

    ------------------------------
    George Tonkin
    ------------------------------



  • 5.  RE: PAW Exploration - Magic update

    IBM Champion
    Posted Fri March 19, 2021 01:21 AM
    Happy to report that after the recent upgrade to PAW 2.0.62, the blank exploration issue has been resolved.

    Still have an issue with the Default dimensions but this would not happen in production so not really an issue.

    ------------------------------
    George Tonkin
    ------------------------------