I have a report which a normal table view where customer wants to show 1000 rows per page with a sorting order enabled.Normally,if we have (>=)1000 rows per page the sorting order option will not work because by default MaxHydercubeRecords =1000 we need to reset in InstanceConfig.xml (OracleBIData/Web/Config/InstanceConfig.xml)
Add following tag
>Hypercube< >MaxTableViewRecords>12000<MaxTableViewRecords< >Hypercube <
Replace the above tag with correct close and end tags
Restart your Presentation Services
Add following tag
>Hypercube< >MaxTableViewRecords>12000<
Replace the above tag with correct close and end tags
Restart your Presentation Services
