How to Display total number of pages / Page number in OBIEE?

If you are trying to display total number of pages in a report, Add the below formula in the column of the report and hide that column in the report.

FX = sum(count(1))/25

You can then reference the column in the narrative view like this: "Total pages in the report are @5" and out put may be "Total Pages in the report are 30".

Or

You can also use something like the below:

To calculate them use fi:
CEILING(CAST(RCOUNT("FactColumn In the Report (Sum All)") as DOUBLE)/ 25) for the page number
CEILING(CAST(COUNT("FactColumn In the Report (Sum All)") as DOUBLE)/ 25) for the total pages

Put the above formula in the column and reference it in the narrative view like I mentioned in the previous example.

Until Next Post... :)