Alias of C element in alternative hierarchy not updated when it matches other aliases in other hierarchy
Created by: RaduCantor
Describe the bug If you have a dimension with many hierarchies, and you want to change the alias of an element in the second hierarchy, Arc will fail to update it if the new alias is the same as another element / alias from another hierarchy.
See the attached screen shots for details:
If we look for example at SData model and pick the Geography dimension, we can create the "Name" alias, the "Regions" alt hierarchy, and change the Name alias for the element "Europe" to "Continent". If we add a new element "New Continent" in the "Regions" hierarchy and try to change the Name alias for the "New Continent" element to "Continent", Arc won't allow us to do it.
This functionality works fine in TM1 11.4 if you use TI:
sValue = 'Continent';
sDim = 'Geography';
sHier = 'Regions';
sElem = 'New Continent';
sAttr = 'Name';
ElementAttrPutS(sValue, sDim, sHier, sElem, sAttr);
To Reproduce Steps to reproduce the behavior:
- Pick an existing dimension
- Create an alternate hierarchy
- Add an alias to the dimension
- Add a C element in the new hierarchy (with some children)
- Try to change the alias of the newly added C element to the name / alias of another C element from the main dimension hierarchy
- You will get the error "data spread failed"
- Try to change the alias to anything else and you can see that it works.
- Try changing the alias by TI and you can see that it works.
Desktop (please complete the following information): Arc version 1.2.1 TM1 version 11.4.0.21 Browser Chrome / Firefox / Edge