Hi All ,
There is an ASO cube and there are around 20 dimensions.
The issue is when I retrieve thru Smartview it gave error message as the no. of rows exceeded the limit.
So I have made the SSPROCROWLIMIT as 1000000 eventually from default value as 250000.
Still I am getting the same error message and surprised that how so many record are processed.
The source has not so many records.
There are are dimensions as retailer and discount codes and each retailer has a particular discount code.
I take Time as col and Retailer and discount code as rows and zoom in the Discount code and it works fine.
When I zoom in the Retailer I get this message.
The version is Essbase 11.1.2.4.
Any suggestions please, how to optimize or get rid of this error, what should be the ideal value for SSPROCROWLIMIT .
-Many Thanks