Hello Everybody,
There are several blog entries which explains about pagination in OBIEE Pivot
Please, include this entry also in that list. J
Suppose, i want to see 10 rows for every page in pivot.
Apart from the columns selected in the criteria for particular request, select another column and modify it’s functionality to CEILING((RCOUNT(1))/10.0). Now, change it’s column heading as: Select Page Number: and drag this column into Pages block of Pivot
Results are like:
Note: In denominator of the formula, use ‘10.0’ instead of ’10’. If you use 10, page Numbers are populated from ‘0’ and in the 0th page only 9 records will be shown for this particular scenario.
Hello,
This is excellent. But when I select Print or Download to Excel or PDF, only the page selected is displayed.
Is there a way to Print all the records or Download all the records?
Download Data is not going to work as formats and other options are missing.
Thanks
can we specify rows on a page to 34 in pivot table?
Where you able to resolve the issue – Download all the records, if pivot table pagination is introduced?
Don’t know in which view you are able to download all records when pagination is introduced?
Even in table view, you can’t download all pages when you are in 1st page
Attempting to add to above formula in existing measure. It keep returning error on RCOUNT function.
Any recommendations?
usually in pivot view itself, if u have thousands of record, it will display only some records, but if u give download it will download all the thousand records…..
IN paginating case if u download, only the page which u selected will be downloaded…
is there any way to download all the data…
Is it possible to do the same in OBIEE 11g Pivot table. As I do not see the Pages section in OBIEE 11g, I am unable to implement the above said functionality. Ideally I want to select pages as above in OBIEE 11g.
In 11g, there is section but it is not called as pages. It is now Table Prompts..