Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Page Number in Analysis result OBIEE 12c

Received Response
1
Views
2
Comments
AA83
AA83 Rank 2 - Community Beginner
edited Aug 13, 2024 5:56PM in Oracle Analytics Forum

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,

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics & AI Lead

    Page number can be inserted from print options.

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.