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

Level0 export error in ASO cube

edited Aug 2, 2018 2:36AM in Essbase 4 comments

Summary

Level0 export error in ASO cube

Content

Hi,

I am trying to export level0 data for a month in ASO cube using MDX query and Report script. I am facing a problem with both of them.

The Account dimension has 1250 members, Geography dimension has 2600 members, LOB has 150 members and the cube holds data from Apr'12 till date.

input_data_size_bytes - 7725744128 bytes (~7.5gb)

aggregate_data_size_bytes - 4683038720 bytes (~4.5gb)

1. The MDX query runs if I select one account without the 'Geography' dimension. But if I select 'Geography', it is throwing an error stating that the output set has is too large to be processed.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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