Sorting order for more than 1000 rows - OBIEE

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