Essbase Studio - Dimension Root not Recognized
Summary
Essbase Studio - Dimension Root not RecognizedContent
I'm trying to build an ASO database but for several dimensions Studio is attempting to add the root as a child of itself.
In my FA dimension table I have this:
PARENT | CHILD |
---|---|
FA | 0000 |
FA | PMB |
PMB | 2000 |
PMB | 3000 |
I've set up self-joins in the minischema for parent-child.
I have a hierarchy that is defined as follows:
FA
- Parent
- Child
But when I preview the hierarchy, it shows this:
FA
- Parent => Child
- FA
- 0000
- PMB
- 2000
- 3000
The cube deployment fails with the error 'Record #1 - Error adding member FA (3317) "FA" "0000" "+"'. If I change the name of the hierarchy to "FunctionalArea", the build for that dimension occurs, but then I have an extra generation that I don't want. My question is how can I specify that FA is the dimension root and not try to build it as a generation 2 member?
0