How to schedule webi report for mulitple prompt values

[former_member387642]

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.

[former_member28818]

Hello Santhana you can read more about tagging here: https://www.sap.com/community/about/using-tags.html

[former_member387642]

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.

[jyothirmayee_s]

Hi,

Is your prompt set to multivalue?.

Thanks,

Jothi

[former_member316829]

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

[former_member387642]

Hi Deepak,

Thanks for your response.

Even if we give all values in universe level,Can we select multiple values for prompt when scheduling the report?

[former_member316829]

Hello,

I would suggest you to go through publication blogs of report bursting on scn portals:

https://blogs.sap.com/2014/06/23/report-bursting-in-business-objects-40/

https://blogs.sap.com/2013/01/31/report-bursting-in-business-objects/

Also, as per your question earlier, you might need to create multiple Scheduled Instances for each segment. For example, you can create a schedule instance for APD OEM1, then another schedule instance for APD OEM2 and so on.

Multiple values of prompts selected:

Yes, You can have multiple prompts, The prompt behaviour is same in case of WebI and Scheduling prompt.

[amitrathi239]

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/

[former_member387642]

Hi Amit,

For dynamic users we can use publications.But is it possible to assign multiple values for prompt using publications?

[amitrathi239]

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.

[jyothirmayee_s]

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

[former_member387642]

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?