Hyperion Essbase (MOSC)

MOSC Banner

Dimension using two hierarchy

edited Feb 27, 2018 4:00AM in Hyperion Essbase (MOSC) 3 commentsAnswered

Hi All,

In essbase studio is it possible to create one dimension using two hierarchies? I know in EIS it is doable.

I have two hierarchies (primary and alternate) coming from two different tables from RDBMD. If i create both primary and alternate roll up in same hierarchy i get error.

Hierarchy_1: (for Dim 1)

Primary (Table A)

      parent code

     child code

Alternate (Table

     alt parent code

     alt child code

"Cannot close cube outline. Essbase Error(-1): Concurrent requests attempting to use the same network connections. Session may be inconsistent" 

Any idea on error/work around or Is below possible somehow?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center