Post date: 12-May-2014 05:32:26
Using Substitute Variable on a Selector
1. SQL Passthrough
- Create SQL Passthrough “YearTime_Selection”
- Define SQL Queries
2. Selector List
- Create Selector “To”
- Apply SQL Passtthrough “YearTime_Selection” (from step 1)
3. Create Workbook Script (Global, this workbook script can be reusable)
- Create Workbook Script “Create Tokens”
- Create procedure “CreateCurTime”
- Add method using “AddTokensFor SubstVars”
- Define token name as [T.CurMonth]
“
4. Execute Procedure on View Workbook Script
- Create Event “AfterContruct”
- Add method “Execute Procedure”
- Apply the procedure “Create Tokens (CreateCurTime)” (from step 3)
