Dimension using two hierarchy
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?