Wednesday, February 27, 2013

OBIEE 11g - Enabling Sorting order for more than 1000 rows

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