Update the view with multiple hierarchies and MDX

Hello Product Management Team,

Based on documentation, there is no direct built in functionality to dynamically update a views MDX based on a selection cell within a book in PAW. The StrToSet function can be used to dynamically define sets in MDX, but it does not support automatic view updates within a book triggered by user selection in a cell.
Additionally, views created or updated via a process do not automatically refresh within a book. This functionality is not supported as per the official documentation.

Our issue is:
We have used a process to update parallel hierarchies for a particular view used in a PAW book.

If we then reopen this view in the Workbench, we can see the change.

If we have actively opened the view both in the workbench and in the book and execute the process, the view is not updated. Only when we close the view and then open it again is the update included.

There is a problem with updating the view / updating the MDX expression.

Thank you in advance.
With best regards,
Vitalij

Needed By

Yesterday (Let's go already!)

Post comment

Guest

Jul 11, 2025

Hello Stuart,
maybe I oversee some brackets or maybe there is sth else.
And one question in advance concerning refresh and process:
If we create a new view by process and we use a RestApi-call to refresh the view, do we get the refresh, even if the view is already open?

I have a sample for a Set MDX:

STRTOSET("[dim_Measure].[" +"test"+ "].Members")
If I select the test hierarchy, this MDX is valid.
If I am at another hierarchy in the set, I get the following error:
##################
MDX error
Validation failed.The server is temporarily unable to service your request due to a TM1 execution error. Please try again later or contact your administrator.
##################

Here is a sample MDX for the view cell with a possible hierarchy name: test
The name is: cub_User_Raum_neu with 3 dimensions: dim_User / dim_Raeume / dim_Measure
###################
SELECT
{
STRTOSET("[dim_Measure].[" +
[cub_User_Raum_neu].(
[dim_User].[11],
[dim_Raeume].[raum2],
[dim_Measure].[kommentar]) +
"].levels(0).Members")
} ON 0,
{
[dim_Raeume].[dim_Raeume].MEMBERS
} ON 1
FROM
[cub_User_Raum_neu]
WHERE (
[dim_User].[dim_User].[11])
###################

If I put this to the view, I get the following error message:
Unable to update MDX. CellsetMismatch: dRx2SY8QAIAcAAAg

If I put the StrToSet-expression to the Measure-dimension with the hierachy test, everything is fine:

If I put the following expression:
###############################
SELECT
{
STRTOSET( "" +
[cub_User_Raum_neu].
([dim_User].[11],[dim_Raeume].[raum2],[dim_Measure].[kommentar])
)
} ON 0,
{
[dim_Raeume].[dim_Raeume].MEMBERS
} ON 1
FROM
[cub_User_Raum_neu]
WHERE (
[dim_User].[dim_User].[11])
###############################
I don't get any error, however, the dim_measure-dimension is going to the "workbench", however, not with the right hierarchy, but there at least is no further error.

Another sample could be with the real selection cube with 3 dimensions:
}Clients / dim_Dimensnion / measure_dim
I try to simulate the following behavior:
// [Proj].[only_RS].LEVELS(0).MEMBERS
#####################################
SELECT
{
[dim_Measure].[dim_Measure].MEMBERS
} ON 0,
{

STRTOSET("[Proj].[" +
[cube_Selection].(
STRTOMEMBER("[}Clients].[" + USERNAME + "]"),
[dim_Adim].[Proj],
[dim_Measure].[Selektion_6]) +
"].Members")

} ON 1
FROM
[Product_Cube]
WHERE (
[dim_Versi].[dim_Versi].[All_VERSI^12xx],
[dim_Mema].[dim_Mema].[All_Measures^Month])
#####################################
Thanks in advance.

With best regards,
Vitalij

Reply
Hide replies

Guest

Jul 8, 2025

is there any update?

Reply
Hide replies

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

Update the view with multiple hierarchies and MDX