Planning Analytics

Hello, I'm having an issue when I try to update a dimension hierarchy by pasting a value in from Excel. For instance, when I copy a value in Excel then try to "Add" to the hierarchy, whether I select as a Child, Parent, Before Selection, or After Selection, it gives me the error "Dimension [dimension name] has invalid rules." This was never an issue when using the Classic dimension editor, but just started with the recently updated editors. I've tested Safari, Chrome, and Firefox and all have the same issue. It also occurs on all dimensions in our cubes.

Is there a setting that needs to be adjusted to correct for this? Some other solution? Any help here is appreciated!

#PlanningAnalyticsWorkspace

Hi Stephen,

The new dimension editor supports pasting multiple new members from Excel on your first paste.

Then you  can paste single members to the hierarchy from Excel. You'd need to commit the newly added members.

Best regards,

Hello, I'm having an issue when I try to update a dimension hierarchy by pasting a value in from Excel. For instance, when I copy a value in Excel then try to "Add" to the hierarchy, whether I select as a Child, Parent, Before Selection, or After Selection, it gives me the error "Dimension [dimension name] has invalid rules." This was never an issue when using the Classic dimension editor, but just started with the recently updated editors. I've tested Safari, Chrome, and Firefox and all have the same issue. It also occurs on all dimensions in our cubes.

Is there a setting that needs to be adjusted to correct for this? Some other solution? Any help here is appreciated!

#PlanningAnalyticsWorkspace

Hi Svetlana, thank you for responding! I'm not able to get to the point where I would commit the members. The error happens immediately after I try to paste the elements. I've taken a screen recording so you can see when/where/how the error occurs. I've uploaded the recording and also included a youtube link below where I have saved it. Hopefully, one of these videos will work for you. Thank you in advance for any further help you can provide!

Planning Analytics Dimension Error

------------------------------
Stephen Wickwire

Original Message:
Sent: Fri January 19, 2024 05:13 PM
From: Svetlana Pestsova
Subject: Dimension...has invalid rules.

Hi Stephen,

The new dimension editor supports pasting multiple new members from Excel on your first paste.

Then you  can paste single members to the hierarchy from Excel. You'd need to commit the newly added members.

Best regards,

------------------------------
Svetlana Pestsova
IBM Planning Analytics Product Manager

Original Message:
Sent: Fri January 19, 2024 11:52 AM
From: Stephen Wickwire
Subject: Dimension...has invalid rules.

Hello, I'm having an issue when I try to update a dimension hierarchy by pasting a value in from Excel. For instance, when I copy a value in Excel then try to "Add" to the hierarchy, whether I select as a Child, Parent, Before Selection, or After Selection, it gives me the error "Dimension [dimension name] has invalid rules." This was never an issue when using the Classic dimension editor, but just started with the recently updated editors. I've tested Safari, Chrome, and Firefox and all have the same issue. It also occurs on all dimensions in our cubes.

Is there a setting that needs to be adjusted to correct for this? Some other solution? Any help here is appreciated!

#PlanningAnalyticsWorkspace

------------------------------
Stephen Wickwire
------------------------------

Hello, I'm having an issue when I try to update a dimension hierarchy by pasting a value in from Excel. For instance, when I copy a value in Excel then try to "Add" to the hierarchy, whether I select as a Child, Parent, Before Selection, or After Selection, it gives me the error "Dimension [dimension name] has invalid rules." This was never an issue when using the Classic dimension editor, but just started with the recently updated editors. I've tested Safari, Chrome, and Firefox and all have the same issue. It also occurs on all dimensions in our cubes.

Is there a setting that needs to be adjusted to correct for this? Some other solution? Any help here is appreciated!

#PlanningAnalyticsWorkspace

Hi Stephen,

Let's say that you have two dimensions, let them be DimA and DimB, and both are part of a cube, CubeOne. Later on, you add a member to DimB, let's say ElementA, that already exists in DimA, and ElementA is part of the rules in CubeOne. If ElementA is not fully qualified, that is ['DimA':'ElementA'], you will have an ambiguity problem and the CubeOne rule will fail. Therefore, you will not be able to update DimB, because a rule validation error. Must of the time is not that obvious. Hope this helps.

Regards.

------------------------------
Jose Luis Senas
Data Analyst
Kimberly-Clark Mexico
Mexico City

Original Message:
Sent: Fri January 19, 2024 11:52 AM
From: Stephen Wickwire
Subject: Dimension...has invalid rules.

Hello, I'm having an issue when I try to update a dimension hierarchy by pasting a value in from Excel. For instance, when I copy a value in Excel then try to "Add" to the hierarchy, whether I select as a Child, Parent, Before Selection, or After Selection, it gives me the error "Dimension [dimension name] has invalid rules." This was never an issue when using the Classic dimension editor, but just started with the recently updated editors. I've tested Safari, Chrome, and Firefox and all have the same issue. It also occurs on all dimensions in our cubes.

Is there a setting that needs to be adjusted to correct for this? Some other solution? Any help here is appreciated!

#PlanningAnalyticsWorkspace

------------------------------
Stephen Wickwire
------------------------------

Hi Stephen and Jose,

Thank you for your posts. The error is coming form the tm1 server side and it'd be necessary to see the Logs messages.

I'm looking  in message improvement to identify the problem better.

Best Regards,

P.S. Stephen, if you could post the related log errors and which version are you using v11 or v12, I'd log the enchancement accordingly.

------------------------------
Svetlana Pestsova
IBM Planning Analytics Product Manager

Original Message:
Sent: Tue January 23, 2024 09:31 AM
From: Jose Luis Señas Cuesta
Subject: Dimension...has invalid rules.

Hi Stephen,

Let's say that you have two dimensions, let them be DimA and DimB, and both are part of a cube, CubeOne. Later on, you add a member to DimB, let's say ElementA, that already exists in DimA, and ElementA is part of the rules in CubeOne. If ElementA is not fully qualified, that is ['DimA':'ElementA'], you will have an ambiguity problem and the CubeOne rule will fail. Therefore, you will not be able to update DimB, because a rule validation error. Must of the time is not that obvious. Hope this helps.

Regards.

------------------------------
Jose Luis Senas
Data Analyst
Kimberly-Clark Mexico
Mexico City

Original Message:
Sent: Fri January 19, 2024 11:52 AM
From: Stephen Wickwire
Subject: Dimension...has invalid rules.

Hello, I'm having an issue when I try to update a dimension hierarchy by pasting a value in from Excel. For instance, when I copy a value in Excel then try to "Add" to the hierarchy, whether I select as a Child, Parent, Before Selection, or After Selection, it gives me the error "Dimension [dimension name] has invalid rules." This was never an issue when using the Classic dimension editor, but just started with the recently updated editors. I've tested Safari, Chrome, and Firefox and all have the same issue. It also occurs on all dimensions in our cubes.

Is there a setting that needs to be adjusted to correct for this? Some other solution? Any help here is appreciated!

#PlanningAnalyticsWorkspace

------------------------------
Stephen Wickwire
------------------------------