Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

Consolidating Multiple Database Outlines

Content

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.

Register

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