Planning Analytics

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

Websheets in Workspace offers what is fundamentally a Dimension-Selection synchronization pattern, which is not a Subset-Selection synchronization as you said.

This is an area I'm always interested to see further improvements in.  We've done a number of things in this space this year (for synchronization), and I expect that trend to continue.

Nothing specifically for this that I can share, but I'll continue internal discussions about it.

Regards,

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

What do you mean by this: As long as the correct subset is selected in the filter?  

What I mean is, if I use subset editor in the filter and select the subset that was used in Excel (by selecting the set on the left and not the elements per below), the dropdown then gives me the elements from the subset:



From Subset Editor (Test Delete is my subset)


Published sheet:



i.e. the same elements.  i.e. do you have the subset selected in the filter.

Why are you changing the subset in Excel as part of your testing? - This was not part of my test? It is all within PAW where the problem occurs, and there is no change in subset?

Just further checking the behaviour

The whole point is that I can synchronise between 2 different PAX reports published in one PAW book but on 2 different tabs. So the scope has to be the book.

Was just asking if it improved the behaviour.  If you have something on another tab, it might be affecting the behaviour of the selection.

Maybe I'm missing the point here.

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

What do you mean by this: As long as the correct subset is selected in the filter?  

What I mean is, if I use subset editor in the filter and select the subset that was used in Excel (by selecting the set on the left and not the elements per below), the dropdown then gives me the elements from the subset:



From Subset Editor (Test Delete is my subset)


Published sheet:



i.e. the same elements.  i.e. do you have the subset selected in the filter.

Why are you changing the subset in Excel as part of your testing? - This was not part of my test? It is all within PAW where the problem occurs, and there is no change in subset?

Just further checking the behaviour

The whole point is that I can synchronise between 2 different PAX reports published in one PAW book but on 2 different tabs. So the scope has to be the book.

Was just asking if it improved the behaviour.  If you have something on another tab, it might be affecting the behaviour of the selection.

Maybe I'm missing the point here.

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark

What do you mean by this: As long as the correct subset is selected in the filter?  

What I mean is, if I use subset editor in the filter and select the subset that was used in Excel (by selecting the set on the left and not the elements per below), the dropdown then gives me the elements from the subset:



From Subset Editor (Test Delete is my subset)


Published sheet:



i.e. the same elements.  i.e. do you have the subset selected in the filter.

Why are you changing the subset in Excel as part of your testing? - This was not part of my test? It is all within PAW where the problem occurs, and there is no change in subset?

Just further checking the behaviour

The whole point is that I can synchronise between 2 different PAX reports published in one PAW book but on 2 different tabs. So the scope has to be the book.

Was just asking if it improved the behaviour.  If you have something on another tab, it might be affecting the behaviour of the selection.

Maybe I'm missing the point here.

Hi,

I have created a PAX dynamic report which is published in PAW.

There is a Subnm in the PAX report for version, as follows:

=SUBNM("Server:Version","PAW_Active Versions",1)

This should return members of the subset, PAW_Active Versions.

Within PAW I am synchronising the version dimension (it should be noted that if synchronisation is turned off the problem I describe below does not appear, therefore I am pretty confident this is caused by synchronisation).

When I first load the PAX sheet in PAW, in the version dropdown I see the correct elements, as per image below:

However, once I make a selection from the dropdown, it returns every member of the dimension and no longer returns the elements in the PAW_Active Versions subset, as per image:

Has anyone else experienced this or can confirm my results? 

I have raised this with IBM support, but the number of hoops they are asking to jump through just to kick start their research means I thought I would share this here  too!

Edit: PAW version is v63. PAX is the latest too.
 

Regards, 

Mark