Greetings, I was requested to create a report in a BSO cube in HFR but, I am getting the following errors:
Error executing query: Native: 1012709 Unable to load the data entry form as the number of data entry cells exceeded the threshold.
Error executing query: The number of query result cells exceeds the limit set by the QUERYRESULTLIMIT Essbase configuration setting.
It is a large cube. data block size is 183KB 3 dense dimensions and, 6 sparse dimensions. My question to the community is would I still get the same error in an ASO cube. Also, what is the protocol to get Oracle to increase the QUERYRESULTLIMIT setting to get the report to render. Any thoughts are appreciated. Thank you in advance.