This content has been marked as final. Show 2 replies
I could able to do this for all reports in one shot by modifying the Instanceconfig.xml , with the below tags, make sure to put these tags before AdvancedReporting area.
To limit number of rows in table view check this : http://gerardnico.com/wiki/dat/obiee/obiee_limit_clause
For pivot : http://obiee101.blogspot.com/2008/02/obiee-controling-pivot-view-behavior.html
You can also mention the rows to return in the pivot table properties.
NOTE: Please mention if this resolved your problem/still facing and close the thread to assist others with similar problems.