Metadata builder and extensibility
Hi everyone,
I am currently using the metadata builder in excel to maintain and keep updated the hierarchies of all dimensions, but I'm having an issue in loading two separate dimensions for UD5.
I was planning to build the U5 dimensions as follows:
within each dimension, I would have the same base members organized in different hierarchical structures (aka same base members but different nodes between Finance and HR).
In Excel, I divided the two dimensions in two separate sheets, because I can reference one dimension at a time in each sheet
when I load the XML of the first dimension, I have no issues and the dimension loads as expected. If I make a change to the configuration of that same dimension and load the new xml, I still get no issues.
The problem arises when I try to load the XML of the second dimension. The error I get is the following:
Error processing XML file type 'Metadata'.
Error processing XML.
The specified member does not belong to the encompassing dimension. 169989, Cost Centers HR. XML line 127, position 7, element member.
The 169989 member is the first base member in the HR dimension. It seems the system refuses to load members that already exist in the Finance dimension.
My questions are the following:
- Is there a problem in the way I designed the UD5 dimensions in excel?
- OR is it normal that the same base dimension can be loaded for one dimension only, and the second XML (for the HR dimension) should only include the new relationships between the already existing base members and the new nodes of the HR dimension?
Thank you in advance for any help, feel free to ask additional info if needed