Scheduling in Webi Reports with Changing Prompts.

[Former Member]

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

[Former Member]

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

[Former Member]

Mallikarjuna,

                  I have a similar requirement where I'm using a dynamic recipient list and I can use publications with a crystal/webi as my recipient list source. But I have different prompts for different emails. Publications allow me to use the same prompts to multiple users.

Is there a way to schedule the WebI with different prompts to multiple recipients?

[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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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-bd07546a1...

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

[Former Member]

Thank you for the reply, Aashutosh.

if you create customer exit variable for As of Date for current date, the user cannot run for other dates, right?

I need to schedule the report on daily basis as well as for different dates based on the user requirement manually.

Can it be achieved???

Regards,

Abdul

[Former Member]

Hi Abdul,

You would use the customer exit to populate the default value for AS of Date prompt, so you can always override the default value and run for other values in webi prompts.

Thanks

Mallik

[Former Member]

Hi Abdul,

As Mallikarjun said, you can override the default value.

The other thing is that as the report is going to schedule on daily basis, user can refer the any previous instances of scheduled documents for desired date. Why is there a need for separate schedule? With new schedule, you are actually duplicating your work. You can restrict the no.of scheduled instances to be generated.

Regards,

Aashutosh

[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