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=PAOCThanks
------------------------------
Charbel Abou-Khalil
------------------------------
Original Message:
Sent: Tue March 02, 2021 04:50 AM
From: Mark Wragg
Subject: Planning Analytics Workspace Column Widths
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
Original Message:
Sent: Mon March 01, 2021 09:51 AM
From: Charbel Abou-Khalil
Subject: Planning Analytics Workspace Column Widths
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
Original Message:
Sent: Fri February 26, 2021 04:33 AM
From: Mark Wragg
Subject: Planning Analytics Workspace Column Widths
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:
------------------------------
Mark Wragg
------------------------------