Planning Analytics with Watson

Expand all | Collapse all

Planning Analytics Workspace Column Widths

  • 1.  Planning Analytics Workspace Column Widths

    Posted Fri February 26, 2021 04:34 AM
    Hi,

    I have created filter selections for views in PAW using mdx.
    Everything seems to work well except that when I save the book it does not save the column widths of views for other users. 

    Let me illustrate, when I create the book, add in the view, extend the column widths and save the book, the next time I open the book it remembers the column width as per the image below:



    However, when another user opens the same book the column width is narrower, as per image below:



    I have hidden the Column headers because this is the name of the logged in client and I don't want to show that. 

    It would appear the only way to adjust and keep the the column width to the desired length is for the user to edit the view and expand the width manually and then save the book, but for most users this book would be View only and they do not have full control. 

    The other option would be to show the column header, which I don't want to do, and then have the user manually adjust the column width every time they go into the report. Not exactly ideal!

    It is more than a little frustrating to go to a lot of effort to get filters to work, and then trip up over some trivial formatting issues, but of course to end users this is not trivial at all! 

    I really feel issues like this need to be dealt with, unless of course I have missed something, and you can ensure the column width is standardised for each user? 

    Regards, 

    Mark



    ------------------------------
    Mark Wragg
    ------------------------------


  • 2.  RE: Planning Analytics Workspace Column Widths

    Posted Mon March 01, 2021 06:18 PM

    Hi Mark, 
    The column width size is not user specific and is persisted/saved as part of the book Cube view widget content. I would not expect that different users see different things if they opened the same book.

    Can you confirm:

    1 - The version of PAW used.
    2 - There are no errors in browser console.

    Additionally are you able to reproduce using one of the same databases and provide us with the book export for additional validation.?

    Thanks.



    ------------------------------
    Charbel Abou-Khalil
    ------------------------------



  • 3.  RE: Planning Analytics Workspace Column Widths

    Posted Tue March 02, 2021 04:51 AM
    Edited by Mark Wragg Tue March 02, 2021 05:06 AM
    Hi Charbel,

    thanks for the reply.

    I have done some further testing and believe it is related to the MDX being used in the subset.
    In the example I gave the cube view was looking at the client attributes cube, with the client dimension in the column, and in order to return data for the logged on client I have used the following mdx:

    {STRTOMEMBER("[}Clients].[}Clients].[" + USERNAME + "]")}

    It would appear it is the fact that the element changes depending upon which user logs in which is causing the column width not to persist.

    So for example, if the logged in client is say, "Test User Example A" then Test User Example A will be the element returned by the MDX, whereas if the logged in client is "User X" then User X will be the element. Test User Example A and User X are different lengths, I am wondering if this is somehow causing the column width not to persist.

    Whatever the reason I would view this has a bug.

    I should add that we are on version 2.0.59 of workspace

    regards,

    Mark



    ------------------------------
    Mark Wragg
    ------------------------------



  • 4.  RE: Planning Analytics Workspace Column Widths

    Posted Tue March 02, 2021 11:42 AM
    Thanks Mark.

    You are correct.

    It is caused by the used MDX. The MDX is changing the member per user. The column extents are tied to the member. e.g. the Width of the column. If that member is no longer there the extents (width in this case) is no longer applicable.

    This design, is intentional to allow for member specific extents to be carried over as the member moves around in the grid on the same axis. E.g. Operations Hide/Keep/Drill/Expand/Collapse. You will notice how the member moves into various columns positions yet the width is persisted.

    As it stands we do not have the capability to perform extent changes for a fixed column position and disregard members as the context.

    This is a good candidate for an enhancement request. Please consider logging an enhancement here: https://ibm-data-and-ai.ideas.aha.io/?project=PAOC

    Thanks

    ------------------------------
    Charbel Abou-Khalil
    ------------------------------



  • 5.  RE: Planning Analytics Workspace Column Widths

    Posted Wed March 03, 2021 07:57 AM
    Hi,

    FYI I have logged the enhancement request here:

    https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-506

    regards,

    Mark

    ------------------------------
    Mark Wragg
    ------------------------------



  • 6.  RE: Planning Analytics Workspace Column Widths

    Posted Thu March 04, 2021 01:45 PM
    Hi Mark,

    I see the enhancement request.  We will review this request with our design team as we are working on the updated design for the Workspace cube viewer.

    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------



  • 7.  RE: Planning Analytics Workspace Column Widths

    Posted Thu March 04, 2021 03:13 PM
    Hi Stuart, 

    Yes, please take this into consideration. I am also struggling a lot with the column widths.

    Thanks,
    Mario

    ------------------------------
    Mario Hasler
    ------------------------------



  • 8.  RE: Planning Analytics Workspace Column Widths

    Posted Mon March 08, 2021 08:53 AM
    Stuart, I am having a problem with this, as well.  I hope you will consider a fix to this.

    ------------------------------
    Kristy Sadaro
    ------------------------------