Skip to Content

How to schedule webi report for mulitple prompt values

Hello Everyone,

Environment : SAP BO:4.2

Back End : Oracle

I want to schedule the webi report daily for multiple prompt values.

Once the database loads complete success fully,I want to execute the report for all the values.

For Example,

In database table,I have a column called product name and in webi report i have a prompt called product name.

If 25 records loaded today,for those 25 values the webi report should schedule automatically.

Is it possible to do in webi?

If possible,please help me to achieve this.

Thanks,

Santhanaa.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Mar 03, 2017 at 05:56 PM

    Hi,

    Right click on the report >> select Schedule >> you will see the options on your let hand side.

    Select Format, destination and Recurrence. You can also select prompts.

    Make sure you have access to schedule a report.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jothi,

      Thanks for your response,

      We can give single value for the prompt during scheduling.I am aware of the steps which you have explained.

      But my Doubt is, How to give multiple values for prompt during scheduling?

      For example,

      my prompt is:"Product name"

      Value for prompt is product1,product2.....etc up to product10 .

      So I want to schedule the report for multiple values.For value "product1" separate report should be generated likewise for product2,product 3 etc..

      Any help Guys?

  • Mar 07, 2017 at 09:06 AM

    You need use Publication to get the individual report for each product.

    Check attached links to get information how to use publication in your query.

    https://blogs.sap.com/2014/01/07/create-publication-to-schedule-webi-report-to-dynamic-recipients/

    https://blogs.sap.com/2013/09/16/webi-publishing-through-dynamic-recipients-and-issues-faced/

    Add comment
    10|10000 characters needed characters exceeded

    • You have mentioned for each Product value you want one file.like if you have 10 product values then one report file for each product.

      If above one is your requirement then yes you can achieve this by publication.

      If something else are you looking then plz explain.

  • avatar image
    Former Member
    Mar 07, 2017 at 09:29 AM

    Hello Santhanaa,

    As per your scenario, you are taking Product name in prompt, you have today suppose Product names A,B,C and you have scheduled a report using these values.

    But after the load there is addition of values in Product Name A,B,C,D. Now, the scheduled report would be still taking A,B,C as values. From what I believe you cannot automate this.

    Now, you can have a work around for this, create a Prompt Filter in the universe for Product Name which has a default Value as "All". In the report use the "Product Name Prompt Filter" in the report query.

    When you schedule select "ALL" value in the prompts.

    For creating "ALL" value in the prompt filter refer: https://archive.sap.com/discussions/thread/1201562

    Thanks,

    Deepak

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 11:15 PM

    Hi,

    Is your prompt set to multivalue?.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2017 at 11:20 AM

    Hello Guys,

    I got a suggestion like we can achieve this using JAVA SDK.

    So currently am searching about that.

    The report is one,prompt is one,totally twelve values for the prompt.

    User do not want to select anything in reports.

    so as soon as the records are uploaded in database level,the reports should schedule.

    Previously we suggested client like,as soon as the etl loads completed one text file should be placed in particular folder.

    As soon as the file placed,the report schedule should start.

    But they said like,everything should be automated.So we have chosen java sdk approach.

    If once it is successfully implemented, i will update the method which we have followed.

    Add comment
    10|10000 characters needed characters exceeded