Hello,
I have an existing time dimension with a default hierarchy (Period). It has the structure of Total Periods > Year > Quarter > Month
I added a new hierarchy, QTD. I want it to have the structure of Total QTD > Year QTD > > Month QTD. For example, Feb 2020 QTD would have leaf elements of Jan 2020 and Feb 2020.
I am able to create the consolidations. For example, I have Total QTD > 2020 QTD > Feb 2020 QTD, however I am unable to figure out how to add the leaf elements under the consolidation. I tried to copy and paste from the other hierarchies (Period and Leaves) but not able to paste. I receive an error: An element with name "Jan 2020" already exists. Failed to create element.
I don't know if I am missing something or if that's not even possible.
Thank you.
The problem was an alias attribute contained the same value 'Jan 2020'. Once I changed that I was able to paste the value into the alternate hierarchy.