He was making a large sheet but when retrieving he was getting a error:
The solution was ‘simple’:
In the APS (Provider Services) there is a file that limits the maximum records that can be retrieved.
You can edit the file ‘essbase.properties’ to remove the limit.
To find the file , you can just go to the webpage of your installation:
http://localhost:9000/aps/APS (in weblogic)
http://localhost:19000/aps/APS (in OHS)
Edit the file ‘D:\Oracle\Middleware\EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0/bin/essbase.properties' so that smatview can retrieve more than 5000 records.
Go to the following line: ‘service.olap.dataQuery.grid.maxRows’
# Specifies maximum rows/columns for dataquery grid. 0 value indicates no limit.
#service.olap.dataQuery.grid.maxRows=5000
service.olap.dataQuery.grid.maxRows=0
service.olap.dataQuery.grid.maxColumns=255
Keep in mind that Excel has a limit in record that can be handled:
Excel 2003: 65536
Excel 2010: 1048576
Restart the APS and your done.
