2 Replies Latest reply: Feb 29, 2012 12:49 PM by PoojaK RSS

    Pivot Table - Rows displayed

    PoojaK
      Hi,

      I have a pivot table report which display complete report instead of showing 25 rows first.

      Due to large number of rows we are getting Out of memory issue.

      Is it possible to display 25 rows first in Pivot table. Please help - as users are unable to test this report.

      Thanks,
      Poojak
        • 1. Re: Pivot Table - Rows displayed
          MuRam
          Hi,

          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.
          <Views>
          <Table>
          <DefaultRowsDisplayed>100</DefaultRowsDis played>
          </Table>
          </Views>

          Or Try:
          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.

          Regards,
          MuRam
          • 2. Re: Pivot Table - Rows displayed
            PoojaK
            Thanks for replying to my issue.

            Could you please tell me where can I see pivot table properties. I am unable to find thia.

            You can also mention the rows to return in the pivot table properties.

            Thanks,
            poojak