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.