Hyperion EPM General (MOSC)

MOSC Banner

11.1.2.3.500 - location of consolidation operator value in Planning applications SQL databases

edited Jan 7, 2025 8:23PM in Hyperion EPM General (MOSC) 2 commentsAnswered ✓

Hi, what table and column is the consolidation operator now stored in 11.1.2.3.500? It was the HSP_MEMBER table and the fields CONSOL_OP1 through to 7 but new members that are being created have NULL has the consolidation operator. Previous members present before in 11.1.2.1 before the upgrade to 11.1.2.3.500 are have their consolidation operators. This is not impacting Planning or Essbase but routine to extract the consolidation operator included when creating a new EPMA dimension load file via a SQL routine. There are over 30 new tables in a planning application but none of these contain it.

Thanks, Nathan

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center