Question & Answer
Question
In a dimension with six alternate hierarchies, I'd like to synchronize in a rule a "Code-Name" alias for C level elements, which are the same thing hierarchy to hierarchy.
For example, in the main Hierarchy, Code "M1000" is a parent that has dozens of children.
M1000
-M1000.01
-M1000.02
-etc...
-M1000.01
-M1000.02
-etc...
The Code is "M1000" and the Name is "Fred", therefore the Code-Name alias is "M1000 - Fred".
In the nonmain hierarchy, I'd like to write a rule that says:
['Code-Name', in AltHierarchyX or all Alt Hierarchies ] =C: DB(Attributes cube of this dimension, <general addressing to base hierarchy> of element, 'Code-Name);
['Code-Name'] = C: (AttrCube, 'Dim':'BaseHier': Element, 'Code-Name');
I'm assuming it isn't possible given it's an alias, since there's no way to know which C: level element in which hierarchy it's referring too and identically named parents in multiple hierarchies that are the same thing cannot share an alias.
If my assumption is true, I can't even do it in a TI on a Hierarchy rebuild because that too would theoretically violate uniqueness.
Therefore, what would be the best practice?
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m3p000000PC7BAAW","label":"Planning Analytics-\u003EArchitect-\u003EModel and Reporting"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
02 April 2023
UID
ibm16967689