Skip to Content
avatar image
Former Member

Scheduling in Webi Reports with Changing Prompts.

Hi Experts,

I have a Webi report which is on top of 2 BEx queries connected through BICS. The Webi report has more than 4 crore records which makes it difficult to load each time when I refresh. I need to schedule this report so that the user can view the report based on the last instance.

The report has 3 prompts namely Plant, Material and As of Date.

The user uses only Plant and As Of Date. There are only two plants for example A and B. The user needs to run the report for each plant separately for all the days.

Suppose today is 03/07/2013.

The user will run the report with Plant A and As of Date: 03/07/2013 and second time with Plant B and As of Date: 03/07/2013.

Next today is 04/07/2013.

The user will run the report with Plant A and As of Date: 4/07/2013 and second time with Plant B and As of Date: 4/07/2013.

I need your expert opinion in achieving this while scheduling. Hope you understood the scenario and will be helping me out in this.

Thanks in Advance,

Abdul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 03, 2013 at 12:26 PM

    Hi Abdul,

    Please have a look at following SCN document.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60f9702f-bf27-2e10-09ae-bd07546a17db?quicklink=index&overridelayout=true

    You can remove the variable based on Material, if you can bypass the variable.

    If you have only two plants then you can develop two separate WebI douments for Plant A and Plant B as static filters and remove Material variable present in BEx query and use customer exit to restrict the data for current date as As of date and schedule those two documents.

    Regards,

    Aashutosh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello experts,


      I am very interested in this topic, as I have the exact same requirement as Abdul:

      Daily scheduling of Webi reports, based on BEx queries and connected through BICS. Done on BO4.


      I followed Aashutosh's link above, and i read something very interesting on page 3:

      "

      Current Options Using Standard Functionality

      Until BusinessObjects 4.0 is released, it is not possible to use BEx variables (which will be made available by

      the BICS connector) or the last load date variable. This makes it impossible to automate the scheduling of

      Web Intelligence queries filtered by dynamic dates or time-slices (for example, yesterday, last week) using

      standard functionality. "


      Is this already functioning on BO4/Bex? Do you have an idea of how to implement it?

      Thank you!


      Best regards,

      Francisco

  • avatar image
    Former Member
    Jul 03, 2013 at 01:33 PM

    hi Abdul,

    If possible, In the BEx report itself you can put filter restriction as "Current date" and then create 2 schedules each for Plant A and Plant B separately! Give the timing as one after the other.

    regards,

    Sivakami

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2013 at 08:02 AM

    Hi,

    If Material is optional prompt ,You can just Schedule the report twice (one instance with Plant A and other with Plant B) by providing the time interval.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2013 at 10:44 AM

    Hi Abdul,

    You can try and use publications to schedule with personalized set of prompts, In this case if its same user with different set of prompts, so you may need two publications (one for Plant =A and As of Date) and (second for Plant =B and As of Date) and distribute the report output to users BI inbox.

    refer to working with publication section below to see how personalization works.

    http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_bip_bilaunchpad_en.pdf

    Thanks

    Mallik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi vijay,

      Looks like you have to have different WEBI reports with different Prompts for the respective user group.you can not use the same report to restrict the prompts based on user group.