Skip to Content
author's profile photo Former Member
Former Member

Not generating instance when no data

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 03:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 08:01 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.