How to Parameterize SQL from your Data Source

1. Set up a variable for a Fact Build by right clicking properties (see picture)

2. The key to embedding the parameter is to use the curly brackets in your SQL.

select "SecondedToFromRate",

"SecondedToFromLegacySystemID",

"SecondedToFromLegacyEmployeeID", "GCI"

FROM "PeoplePortal_Headcount"

WHERE D_I = '{$DI}'