Page Number in Analysis result OBIEE 12c

Question

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,

Gianni Ceresa · Answer

You are mixing concepts ...

A webpage hasn't page numbers, page numbers exist only when you translate a web page on paper (or PDF) and that's what Asim Cholas posted above, to add page number on print.

If you want to "fake" a concept of page numbers as you said it must be calculated in the analysis itself, instead of "ROWCOUNT" you need more a concept of "ROWNUM" to get the current row number you are seeing, maybe using RCOUNT or RSUM to increment the number row by row.

asim cholas · Answer

Page number can be inserted from print options.