​How to use Custom SQL in Lookup_Ext Function?

I recently saw people asking how to use Custom SQL in Lookup_Ext. I searched for it on line but could not find much written on this subject. So this article will explain in short how we can use this feature in Lookup_Ext function which is less known and uncommon among DS Developers (at least I have not seen many developers using this feature)...

How to Create System Configuration in Data Services

Why do we need to have system configuration at first place? Well, the advantage of having system configuration is that you can use it for the lifetime in a project. In general all projects have multiple environments to load the data when project progresses over the period of time. Examples are DEV, Quality and Production Environments. There...

How to capture error log in a table in BODS

I will be walking you through (step by step procedure) how we can capture error messages if any dataflow fails in a Job. I have taken a simple example with few columns to demonstrate. Step 1: Create a Job and name it as ‘ERROR_LOG_JOB’ Step 2: Declare following four global variables at the Job level. Refer the screen shot...

Custom function in BODS to remove special characters from a string

Below is step by step procedure to write a custom function in BODS to remove special characters in a string using ASCII values. Step 1: Create a custom function in BODS and name it as 'CF_REMOVE_SPECIAL_CHARS' Step 2: Use the below code in your function. # This function is to remove special characters from the string.It...

Substitution parameters in SAP DS

What is substitution parameter? Substitution parameters are used to store constant values and defined at repository level. Substitution parameters are accessible to all jobs in a repository. Substitution parameters are useful when you want to export and run a job containing constant values in a specific environment. Scenario to use...