Added a caption attribute as an alias for dimensions (DimensionAttrInsert) which works beautifully in that I have hierarchies named AF1, AF2, ... and set the aliases so that AF1 displays as "Accounts Forecast", AF2 as "Accounts Forecast 201901", ... in PAW.
However, when passing a parameter for the Hierarchy name to a TI process, I want to verify the hierarchy exists. As the underlying name is not displaying in PAW I want to provide the caption, "Accounts Forecast" so that:
Code: Select all
# psHierarchy is a parameter for the TI: psHierarchy = 'Accounts Forecast'; # Accounts Master is the dimension. AF1 is a hierarchy in that dimension. dimName = 'Accounts Master'; # This returns nHierarchy = 0. nHierarchyExists = HierarchyExists(dimName, psHierarchy);