In this article we are explaining you why we use variable in Cognos Data Manager. Here are some practical scenario where we can use variables.
We can use variables in a SQL Query to filter out data dynamically.
Example: SELECT EmployeeName, EmployeeSalary FROM tblEmployee WHERE EmployeeRegion = $RegionVariable;
We can use variable to handle loops.
We can use variable in Condition block to handle the flow of Cognos ETL.
We can use variables to create dynamic SQL Query.
For example you can use variable to set table name dynamically. Lookup('DBConnection', CONCAT('DELETE FROM ',$tblName,' WHERE 1=1') );
We are working on step by step guide to explain the same.
Your comments will be highly appreciated.