Pagination is possible in OLAP or not??

if possible can you give an example to solove this pagination problem....

This message has been edited. Last edited by: Kerry,

Santhu

Please update your signature, so we know what you are using.
mainframe focus, webfocus, defstudio, version 5.5 or 7.6 it all makes a lot of difference.

What do you mean by "pagination" is that page numbers or something else?

Please try to create an example code with the CAR database and post that trial between the proper codes (see the left upper button in red

</>

.

I want only specified(i.e 100) number of records to be displayed in the report instead of reteriving all records(i.e 10,000).

can we have another option like if it is trying to display me 2000 records then can we redirect it to the reportcaster saying that the record limit is more so, we are sending a mail to ur mail id in the form of excel file. So, that it will reduce the burden of the oracle server as well as web server also.

Can u help me out on this issuse.

Yes Santhu that can be done.
You can test the number of records and than loop to some part of the report that either shows the report or sends you the output by mail in excel.
But you first have to count the records, so in one or other way it needs to enter the database, unless you have some metadata that holds this kind of figures.

A consideration would be to produce a HOLD file with all of your selection criteria then check the number of records, &RECORDS, and branch to a specified label based on the number of records in your HOLD file. Each of the succeeding labels would do whatever you ask it to do.

That nice of &RECORDS and branching using label.
But i want to send a mail to particlar user email id when the record number is more.

Can u give me a sample code for sending a mail in excel format..

Santhu,

Limiting your output to a certain number of records canbe done by setting the retrieval limit to a certain value. But that is just about it. You cannot send mail from within the olap environment nor send a request to report caster. The OLAP tool just is not meant for these things.

Like GamP says OLAP and Report Caster are not compatible.

For managing situations like you have, you need the Resource Governor.

Failing having Resource Governor available your best solution is to submit
your request directly to Caster via the API and always distribute the report
(NONE OLAP) that way.

Shantu

Are you a colleague of Swapna?

You both post the same question about this subject.
I answered you and some others did the same.
But now I see this question again with Swapna.

I think it would be wise if you both go to your management and asks them to send you to some basic training and if you have some project together start making appointments on who does the questions on FocalPoint. This would be more efficient than both posting the same questions.