You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase Studio - Dimension Root not Recognized

edited Aug 2, 2018 2:36AM in Essbase

Summary

Essbase Studio - Dimension Root not Recognized

Content

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
FA0000
FAPMB
PMB2000
PMB3000

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!