Not generating instance when no data

[Former Member]

Hi all,

We have a webi report which may be blank (i.e. no data).

We want to schedule this report to get a acrobat reader file but we don't want that the instance be generated if there is no data.

Is there a way to do this with a scheduling option or by an other trick ?

Thanks in advance for help.

Olivier

[Former Member]

Hi,

You can go for the publications option wherein you can set the delivery rule to send instances only when there is data in it.

Regards,

Neeraj

[Former Member]

The only trick I know is creating the same query at database level in a stored procedure, the stored procedure should count if there are no rows. If there are no rows it won't do anything. If there are rows it should create a text file in the server, let's say the text file is 'C:folderMyDataAvailable.txt'.

Then at BusinessObjects Cmc create an event, the event should check if in the route C:folder the tex file MyDataAvailable.txt has been created. Let's say your event name is MyEvent

At report schedule parameters select in Events this event named MyEvent.

This way the report will run only if the event of the creation of the file MyDataAvailable.txt happens.

If there was another way to do this ... I don't know, this is the only one I know. You should visit Idea Place (http://www.sdn.sap.com/irj/scn/idea-place) to check if in further BusinessObjects versions there will be an option to avoid instance generation if there's no data. Or you could suggest this idea there.

Regards

Erika