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

QUERYRESULTLIMIT - Integration fails with GL due to huge data

Hi Team

We are integrating custom Finance cube in EPBCS application, with the ERP Cloud GL using direct integration, when we try to bring in a month of data at one go, it fails - with error as below

2024-09-19 11:05:00,106 INFO [AIF]: ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1200766): Number of query result cells exceeds the limit [2000000] set by the QUERYRESULTLIMIT configuration setting

The parameters used in integration used are
Ledgers -> @ILvl0Descendants("GRP LS PL"),@ILvl0Descendants("GRP LS RL")
Balance Amount -> "Period Activity","Ending Balance"
Amount Type -> "Base","YTD"

however, when we restrict the above combos into 4 DLRs , it works successfully.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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