2/11/25, 3:25 AM Triggering Process Chain using a Planning Function...
- SAP Community
m
m
Products and Technology Groups Partners Topics Events What's New Get Started
u
ni
t
y
SAP Community Products and Technology Technology
Technology Blogs by Members Triggering Process Chain using a Planning Function...
1
Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP
products, technology, and events. Get in the mix!
Blog What are you looking for today?
Triggering Process Chain using a Planning Function in SAP Design
Studio.
former_member223440
Explorer
Subscribe
2015 Jul 08 7:41 AM
6 Kudos 11,753
SAP Managed Tags: SAP BusinessObjects Design Studio
Currently unlike in WAD ,there is no direct command to trigger a BW Process Chain from
Design Studio. But the functionality can be achieved using a Planning Function. This blog
explains how the Planning function should be defined and executed in order to trigger a
Process Chain from Design Studio.
Step 1: Create a Real time Infocube and include a Characteristic(XZPCCHAIN) and a
Keyfigure (AMOUNT). The Keyfigure doesn't have any purpose, but it is just a [Link]
Characteristic is used to hold the technical name of the process chain, which should be
triggered from the dashboard.
[Link] 1/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Step 2: Go to the Transaction code RSINPUT and load the record in to the Real time
cube, which we created in the previous step. In this case, the Process Chain ID is
Z80_C0XXX_TD_004. I have maintained some dummy value for the Keyfigure
0AMOUNT.
Step 3: Create a Multiprovider(XMX_R01) on top of the Real time Infocube( XCX_R01)
and assign both the Characteristic and Keyfigure. Creating a MPRO enables us to create
an aggregation level on top of it in the next step.
[Link] 2/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Step 4 : Create an Aggregation Level (X80AGGRL) on top of the MPRO, and include both
the Infoobjects( XZPCHAIN and 0AMOUNT) as part of the Aggregation Level.
Step 5: Create a Filter ( X80FILTR) on top of Aggregation Level a restrict XZPCCHAIN
with Process Chain ID Z80_C0XXX_TD_004.
Step 6: Maintain the Function Module RSPC_API_CHAIN_START in the table RSPLF_DIR, so
that it can be called in the FOX formula of the Planning Function.
[Link] 3/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Step 7: Create a Planning Function X80PLANFU on type FORMULA using the
Aggregation Level X80AGGRL. Click on the Parameters tab and define the FOX formula
as shown below. The Process Chain, which should be triggered should be passed to the
Function Module as shown below.
[Link] 4/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Step 8: In the Design Studio, execute the Planning Function by clicking a button and it
triggers the BW Process Chain. Create a button and define the "On Click Event" as
shown below. The syntax is ( PF_1.execute();).
Step 9 : Execute the Dashboard and click on the button , there will be a message as
"Planning Function executed without errors" . If we check in RSPC and the log view of
the PC, we can see the PC being successfully triggered.
[Link] 5/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Tags:
business intelligence business objects design studio
Add tags
Comment
7 Comments
Former Member
2015 Jul 09 12:35 PM
0 Kudos
A handy idea!
former_member438162
Member
[Link] 6/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
2017 May 10 1:20 PM
0 Kudos
I have tried to implement this solution but when I execute the planning function from
design studio, it triggers the process chain 11 times. When i execute from WAD, it is
trigerred only once.
Can anyone help me on this issue.
Thanks
Deepti Prabhu
Former Member
2017 Nov 07 11:16 AM
0 Kudos
Hi Santosh,
great step-by-step guide.
I`ve used this course of action a several times now.
Still wondering a little bit that this function is not incorporated in Lumira Designer like it
was in WAD?
[Link] 7/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Or did I miss something?
Thank you + Best,
Marcus
former_member223440
Explorer
2017 Nov 24 1:55 PM
1 Kudo
HI Marcus,
We took this work-around as there is no direct command to trigger a process chain in
Design Studio. In our earlier projects, we used the BeX WAD ( Web Application
developer) , where this is available.
I am not sure, if there is a direct function available with Lumira.
Thanks
Santosh
Former Member
2018 May 08 9:49 AM
[Link] 8/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
0 Kudos
Hello Santhosh,
We designed as above and executed locally in Design studio we are getting message like
'Design Studio PF1 executed without errors', but the process chain in the BW side not
getting triggered and we dont see any authorization logs at the BW end. Can you help us
if you have any idea what could have gone wrong.
Regards,
Subbu
sheldon_piao
Product and Topic Expert
2018 Jul 16 3:02 AM
0 Kudos
Hi Subbu,
If I am right, this document is just an idea but not enough for fully used for real business
scenario.
If we see the FOX code correctly, we can see that it is designed only to trigger the
process chain, but no further monitor whether the chain is executed successfully or not.
I saw several planning consultants used it in real business system, so I think we need to
know that point at least.
Best Regards,
Sheldon
[Link] 9/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
apradityo
Member
2019 Apr 16 9:34 AM
1 Kudo
nice trick... good to know.. thank you
however, i managed to achieve without following full steps above to make it simpler.
first, you don't need to input process chain name in the real time cube, just input 'dummy
name'. in the planning function, you don't refer to the data anyway.
second, no need to create multiprovider, just create aggregation level on top of the real
time cube.
third, just create filter without any selection.
by doing this, when there is new process chain, you don't need to maintain the real time
cube, just create a new planning function which calls the new process chain.
Comment PREVIEW
[Link] 10/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Hint: # links to products, @ links to members
Email me when someone replies
Cancel Post Your Comment
Labels In This Area
"as_written_by_Marian_Zeis" 3 "automatische backups" 1 "Best Practices" 1
"Data Source Migration" 1 "Integration Challenges" 2 "regelmäßige sicherung" 1
"SAP BW 7.4" 1 "SAP BW" 5 "SAP VARIANT CONFIGURAITION 2
"SAP_BUILD_APPS" 1 "SAPDatasphere" 3 "TypeScript" "Development" "FeedBack" 1
*SAP" 1 -147 Get CurrentUserInfo failed 1 2YM 1 3-TIER Extensibility 3
30 examples 1 505 Technology Updates53 1 @expertsap 2 @hanasizing 1
@RetroDate_HireDateCorrection 1 @sapcommunity 1 @sapilm @archiving @sapiq 1
@SAPSupport 2 @SCPI 2
A Comprehensive Guide to Using OLE Objects in SAP ABAP 1 aATP 1 ABAP 45
ABAP 7.4 2 ABAP API 1 ABAP BAPI BAPI_FIXEDASSET_CREATE1 1 ABAP BTP 1
ABAP CDS VIEW 2 ABAP CDS Views 13 ABAP CDS Views - BW Extraction 3
ABAP CDS Views - CDC (Change Data Capture) 3 ABAP Class 3 ABAP Cloud 9
ABAP Cloud Developer Trial 1 ABAP Custom 1 ABAP DDIC CDS view 1
ABAP development 14 ABAP Editor 2 ABAP Enhancement 1
ABAP Environment & RAP 2 ABAP Extensibility 5 ABAP for EWM 1
[Link] 11/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
ABAP in Eclipse 3 ABAP Interface 1 ABAP New Syntax 1 ABAP ODATA 2
ABAP on HANA 1 ABAP OOABAP 1 ABAP PLATFORM 1 ABAP Platform Trial 2
ABAP Programming 8 ABAP Push Channels 1 ABAP Query 1 ABAP RAP 4
ABAP RAP custom action 3 ABAP RAP(RESTful Application Programming) 7
ABAP RESTFul API 1 ABAP RESTful Application Programming Model 2
ABAP String functions 1 abap technical 1 ABAP test cokpit 1 abap to xml 1
abapGit 1 absl 2 Accenture 1
Access data from datasphere to ADF Azure Data Factory 5
access data from SAP Datasphere directly from Snowflake 1
Access data from SAP datasphere to Qliksense 2 Accessibility 1
Accessibility in SAPUI5 1 Accrual 1 Acquire SAC Knowledge 3 acquired 1
action 1 actions 1 Activity 1 Adaptation Project 1 adapter 2
adapter modules 2 ADDING LEAN SERVICES 2 Addon 2
Adobe Document Services 1 Adobe forms 1 ADS 1 ADS Config 1
ADS with ABAP 1 ADS with Java 1 ADT 4 Advance Shipping and Receiving 1
Advanced ABAP 1 Advanced Event Mesh 4 Advanced formula 1
Advanced Formulas 2 Advanced Metric 1 Advanced SAP Techniques 1
Related Content
Exploring Formats in SAC Add-In for MS Excel
in Technology Blogs by SAP a week ago
Whats New for Planning Area Optimization Within SAP Analytics Cloud QRC1 2025
in Technology Blogs by SAP a week ago
Setting Up a Private SAP Advanced Event Mesh Cluster on SUSE Rancher RKE2
in Technology Blogs by SAP 2 weeks ago
Unlocking the Power of Version Management in SAP Analytics Cloud for Planning
in Technology Blogs by SAP 2 weeks ago
Activity-Related Cost Planning in SAP S/4 HANA
in Technology Blogs by SAP 3 weeks ago
[Link] 12/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
Popular Blog Posts
SAP PI for Beginners
former_member200339
Participant
730265 155 388
[Link] 13/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
ABAP 7.40 Quick Reference
jeffrey_towell2
Participant
1229393 75 345
Difference between SAP S/4HANA :Public Vs Private edition : RISE with SAP
rajarajeswari_kaliyaperum
Active Participant
192944 47 313
Top Kudoed Authors
hardyp180 10
Matthias_BW 7
BjörnS 7
[Link] 14/15
2/11/25, 3:25 AM Triggering Process Chain using a Planning Function... - SAP Community
saroopreddy88 7
Marian_Zeis 6
SachinArtani 5
mike_zaschka 5
Sandra_Rossi 4
Aman07 4
ManabuInoue 4
View all
Privacy Terms of Use
Copyright Legal Disclosure
Trademark Support
Cookie Preferences
Follow
[Link] 15/15
