Enabling 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 <
Regards,

Deva