Hyperion Essbase (MOSC)

MOSC Banner

Synchronising outlines of three cubes

edited Oct 5, 2012 6:26AM in Hyperion Essbase (MOSC) 7 commentsAnswered
Hi all,

I am using essbase adminstration services 11.1.2

I have 3 ASO cubes with identical outlines. Cube A is empty but has transparent partitions to cube B and C for all members. cube B consists of data of the current year. cube C is a kind of history cube.

We use many fact based views for dimension builds meaning that i have to recreate many dimensions with any load. These cubes have about 27 dimensions ( i know that are nearly [too] many). This takes about 50 minutes.

The outline of all three cubes need to be synchronised in some way.

Running the views via rules files for all 3 cubes simultaneously would kill our system. Therefore i tried to copy the otl file from cube A to B and C. This corrupted the outline - i guess because the essbase security file.

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