Cube settings: element selection passed to MDX as member ID not element ID

[Scott Wiltshire]

Describe the bug

When the subset editor is launched from the cube settings dialog and elements are selected and passed back to the MDX properties the fully qualified member names are used not the element names. Only the last part of the fully qualigied member name (after the last carret) which identifies the element shoudl be included in the MDX.

‌

To Reproduce

Launch subset editor and select elements from the cube settings dialog.

‌

Expected behavior

Element name only needs to be passed to the MDX not the fully qualified member name as this is subject to break and cause query to fail should any rollup structures change.

‌

Screenshots

The highlighted part of the member name shouldn’t be included in the MDX!

‌

[Ada Trajer]

Added to backlog

[tomer ganz]

we will add an option on the subset editor to convert to short names

[Scott Wiltshire]

Removing milestone: 2023_Q1 (automated comment)