Hi all,

Is there any way that we could apply resource threshold at a reporting object level. I know we can do that on a master file.

This message has been edited. Last edited by: FP Mod Chuck,

Adding this to your ReportingObject will limit the number of record

WHERE READLIMIT EQ 1000;

and/or

WHERE RECORDLIMIT EQ 1000;

Is that what your looking for ?

Hi Martiny,

Actually we have around 300 reporting objects that we want to set a limit on the output rows that the sql pass through returns. We use resource governor to limit the output rows from the db but i want to know if we can apply a resource threshold on a reporting object so that we can limit the number of rows that it returns.

Thanks,
Aswin Ravikumar

Hi Aswin

I pinged the product manager and Resource Governor only works against master files on the reporting server and not WebFOCUS client Reporting Objects.

Hi Chuck,

Thanks for the update.Is there any way we could customize the message whenever a master file reaches its threshold ?

Thanks,
Aswin Ravikumar

Hi Aswin

When you create a Business Rule to apply you can edit the rule after creating and change the Message1 value to whatever you want.