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.
Tagged:
0