Triggering BW process chain from dashboard

[lakshminarasimhan_n4]

Hi,

We have a process chain in BW system. It runs twice a day to load data from ECC to BW system.

It updates the DSO, over the DSO we have a BEx report and we have WEBI report over the BEx and

we have a dashboard upon this WEBI  report (Query as web  service).

Now business wants to have a button in the Dashboard and when they click it the Process chain  must run.

This is required for them to view the latest data when ever they want, they dont want to schedule the process chain.

Is there any way to achieve this?

Note - The workaround we have, is to have a direct access datasource and BEx report over it, which is connected to Dashboard.

            This will fetch the latest data when the BEx query is accessed from Dashboard.

[Former Member · Accepted solution]

Hi,

You can create a custom program using which you can trigger process chain. Please find a attached doc of how to trigger Process chain from Enterprise Portal is mentioned.

Not sure if this approach can work from dashboard...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f030328f-5496-2d10-b785-c3260ae07...

Hope this helps.

Regards,

[lakshminarasimhan_n4 · Accepted solution]

Hi Ashish,

This triggering must happen from "launch pad" instead of  "Enterprise portal", because users view the dashboard from launchpad. Any idea on that?

[Former Member · Accepted solution]

Hi Lakshmi,

As far as i know event triggering is not possible from launchpad...

Regards,

[lakshminarasimhan_n4 · Accepted solution]

yes,  we have opted the workaround, data will be fetched based on direct access datasource.