Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Consolidating Multiple Database Outlines — Cloud Customer Connect
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

Consolidating Multiple Database Outlines

Received Response
edited Aug 2, 2018 2:36AM in Essbase 1 comment


Consolidating Multiple Database Outlines


Summary: I currently have 3 ASO cubes that house 4,000,000 individual sales transactions per cube. The cubes are segregated by our fiscal year (FY16, FY17, FY18). Each transaction has a unique identifier and the dimensions are exactly the same in all 3 cubes. The only varying member is the transaction # and the various attributes. 


Issue: I'm trying to merge all of the data into one singular cube; however, the outline grew too large and the cube became unusable.


Question: Is there a way (through partitions or other various methods) to have all 3 cubes link to one singular target cube? The main issue would be outline size as I can't combine the three cubes into one because of the size of the combined data. The solution would have to be something that appears to the user that all three cubes are in one singular cube.

Howdy, Stranger!

Log In

To view full details, sign in.


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