2 Replies Latest reply on Sep 28, 2017 9:06 AM by Gianni Ceresa

    Page Number in Analysis result OBIEE 12c

    AA83

      Hello All,

       

      Wanted to display page numbers in Analysis , with Pagination set we can define the number of rows per page but client needs Page number displayed so that after doing Next in pagination he sees if he is on Page 2 or 3 & likewise .

      In version prior to 12c , I think we could display page numbers by playing with ROWCOUNT or CEILING functions and then using the column in Narrative or Pivot prompt.

      But when I do the same now, it is displaying the Total Page count .

       

      Any suggestions ?

       

      Thanks,