- SAP BODS Tutorial
- SAP BODS - Home
- SAP BO Data Services
- SAP BODS - Overview
- SAP BODS - Architecture
- SAP BODS - Data Services Designer
- SAP BODS Repository
- SAP BODS - Repository Overview
- Repository Creating & Updating
- Data Services Management Console
- SAP BODS - DSMC Modules
- SAP BODS - DS Designer Introduction
- SAP BODS - ETL Flow in DS Designer
- SAP BODS Datastores & Formats
- SAP BODS - Datastore Overview
- SAP BODS - Changing a Datastore
- SAP BODS - Memory Datastore
- SAP BODS - Linked Datastore
- SAP BODS - Adapter Datastore
- SAP BODS - File Formats
- COBOL Copybook File Format
- Extracting Data from DB Tables
- Data Extraction from Excel Workbook
- Data Flow & Work Flow
- SAP BODS - Dataflow Introduction
- BODS - Dataflow Changing Properties
- SAP BODS - Workflow Introduction
- SAP BODS - Creating Workflows
- SAP BODS Transforms
- SAP BODS - Transforms Types
- Adding Transform to a Dataflow
- SAP BODS - Query Transform
- SAP BODS Administration
- SAP BODS - Data Services Overview
- Creating Embedded Dataflow
- Debugging & Recovery Mechanism
- Data Assessment & Data Profiling
- SAP BODS - Tuning Techniques
- Multi-user Development
- BODS - Central vs Local Repository
- BODS - Central Repository Security
- Creating a Multi-user Environment
- SAP BODS Useful Resources
- SAP BODS - Questions Answers
- SAP BODS - Quick Guide
- SAP BODS - Useful Resources
- SAP BODS - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
SAP BODS - Creating Embedded Dataflow
You can select an object in the existing data flow. There are two ways in which embedded Data Flow can be created.
Right click on the object and select to make it Embedded Data flow.
Drag the complete and validate data flow from object library into an open data flow in the work space. Next, open the data flow that has been created. Select the object you want to use as the input and output port and click make port for that object.
Data Services add that object as connection point for embedded data flow.
Variables and Parameters
You can use local and global variables with data flow and work flow, which provide more flexibility in designing jobs.
The key features are −
Data type of a variable can be a number, integer, decimal, date or a text string like character.
Variables can be used in the data flows and work flows as function in the Where clause.
Local variables in data services are restricted to object in which they are created.
Global variables are restricted to jobs in which they are created. Using global variables, you can change values for default global variables at run time.
Expressions that are used in work flow and data flow are known as parameters.
All the variables and parameters in work flow and data flows are shown in variable and parameters window.
To view variables and parameters, follow the steps given below −
Go to Tools → Variables.
A new window Variables and parameters is displayed. It has two tabs − Definitions and Calls.
The Definitions tab allows you to create and view variables and parameters. You can use local variables and parameters at work flow and data flow level. Global variables can be used at job level.
A script or conditional in the job
Any object in the job
This work flow or passed down to other work flows or data flows using a parameter.
Parent objects to pass local variables. Work flows may also return variables or parameters to parent objects.
A WHERE clause, column mapping, or a function in the dataflow. Data flow. Data flows cannot return output values.
In the call tab, you can see the name of the parameter defined for all objects in a parent object’s definition.
Defining Local Variable
To define the Local Variable, Open the Real time job.
Step 1 − Go to Tools → Variables. A new Variables and Parameters window will open.
Step 2 − Go to Variable → Right click → Insert
It will create a new parameter $NewVariable0.
Step 3 − Enter the name of the new variable. Select the data type from the list.
Once it is defined, close the window. In a similar way, you can define the parameters for data flow and work flow.