I have a problem with Query in BI 7.0
Query works perfectly in BW3.5 environment. BI 7.0 Vista and Excel 2007 environment I have date range in the query If I provide date range 4 months interval it is working fine.
If I provide 5, 6,7, months interval I am getting the error ,
Critical program error occurred .The program has to close. Please refer to the trace for further information.
Communication error, CPIC return code 020, SAP returns code 223
Client out of memory error
When I execute each interval this query and calculated the no of records it is only less than 19,000 records.
The same query working fine in Bw3.5 for more than year interval.
Advance Thanks .