Planning Analytics

 View Only

 Copy part of dimension (C & N-Level) from one dimension to another within dimension-editor

Jekatherina Fischer's profile image
Jekatherina Fischer posted Tue May 13, 2025 08:19 AM

Hi all,

In Architect, it was possible to copy parts of a dimension within the Dimension Editor and paste them into another dimension. The structure was preserved correctly, including both C-elements and leaf elements. You can do the same in Workbench, but the result looks different: all copied C-elements are transferred as leaf elements. As a result, the hierarchy is lost and needs to be rebuilt manually.

Is this behavior known, and is there anything on the roadmap to adjust it so that it works like it did in Architect? Asking for a client.

Thanks.

Jekatherina

Ronan Gallagher's profile image
Ronan Gallagher posted Thu May 15, 2025 02:27 AM

Hi Jekatherina,

I believe this is solved in the most recent version of workspace: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=20103-change-member-type-consolidated-in-dimension-editor.

In saying that I have not tried it myself as I have not upgraded to this version yet but I watching the IBM PA Q2 product update and they showed creating elements as consolidated type only with no leaves under it (previously it would just default to numeric/string type as you indicated).

If anyone has access to the version of workspace and confirm, let us know!

Ronan 

Amarins van de Voorde's profile image
Amarins van de Voorde posted Thu May 15, 2025 03:16 AM

You could try using bedrock process }bedrock.dim.clone for this: 
https://github.com/cubewise-code/bedrock/wiki/%7Dbedrock.dim.clone

That process allows you to copy a dimensions, including all attributes and all hierarchies, but also only specific hierarchies from the dimension.

Svetlana Pestsova's profile image
Svetlana Pestsova posted Mon June 09, 2025 05:11 PM

Hi Jekatherina,

We do have this limitation in Workbench for dimension editor;

we'd look into better support of the copy/paste on the hierarchical structure,

Best regards,

Svetlana Pestsova

Planning Analytics

Wim Gielis's profile image
Wim Gielis IBM Champion posted Tue June 10, 2025 01:13 AM

There are also similar tools on the market where, without naming them, they allow to copy/paste the dimensional structure. The paste is along different hierarchical structures: parent-child, 1 row for an element and all of its ancestors, etc. Also copy paste from Excel using whatever dimensional layout into a new or existing dimension.

Mark Wragg's profile image
Mark Wragg posted Tue June 10, 2025 08:38 AM

Hi,

This functionality in Architect saved a great deal of time for certain requirements and I am firmly of the opinion that workspace should mirror this Architect functionality.

It is bad enough that Architect is going away, but to be advised to go to the market for basic Architect functionality is hard to swallow. Hopefully IBM will address this as a matter of priority.

regards,

Mark

Related Content