Home / Business Intelligence / Tech Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery
InfoSol Blog Tech Tip

Tech Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery

Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery

Trick: Use Bypass

One of the greatest features of SAP Data Services is the ability to divert dataflows/workflows in a large workflow or job with multiple steps.

This becomes very important when performing system testing or an even more critical situation- recovering an overnight job from failure!

There is a trick to getting this to work, however, you need to create a substitution variable first that will set the bypass to true.

We will cover that as well.

In our example, we are going to bypass a dataflow that is one step in a much larger workflow.

Prerequisites:

Basic skills and knowledge in SAP Data Services

Steps:

Log in to SAP Data Services

Go to Tools -> Substitution Parameters and create new one called $$Bypass = YES

Open a workflow that contains multiple dataflows as steps

Right-click a dataflow and select the Bypass option

Select the [$$Bypass] parameter created before

 

The dataflow will now show a no symbol

Execute the job and the log will show the dataflows as bypassed!

Want more tech tips on SAP Data Services?

Join the Speak BO Webinar Series today and you can view Tyler’s past webinar: SAP Data Services – The Hidden Gem of Data Profiler

Tyler will discuss and demonstrate how to leverage The Data Profiler, a feature few know about that is native within Data Services. This webinar will assist those looking for better insight and resolution into your profiling needs whether it’s for a new ETL project or enhancing an existing work flow.

About Tyler Koitka

Tyler Koitka is a Senior Technical Consultant at InfoSol. Tyler started his career in Australia as a graduate developer at a railway company in Brisbane, Queensland. Becoming quickly fascinated with all things BI & data, he jumped on the chance to learn SAP Business Objects. Seeing great potential in the software, he worked extremely hard to understand and master the tool. After embarking on an adventure with a good friend that landed them both in Canada, he decided to try his luck working in the United States. Upon moving to California in 2013, his first acquisition was a Harley Davidson to cruise the vast American roads. He enjoys staying active, learning new things, traveling and enjoying good company.

Check Also

Skip a Meal and Raise Awareness About Hunger and Poverty

Millions of people around the world are affected by humanitarian crises, but luckily there are ...

Leave a Reply

Your email address will not be published. Required fields are marked *