Working with the Formula Editor
While specifying the object details, you can use the Formula Editor to specify a conditional source location for the object.
To access an object, you must specify the complete path or key of the object in the Formula Editor. To retrieve the complete path or key of the object, use functions or conditional formulas. Refer to the following examples:
- Formula for specifying the path of the query that is directly sourced from the data source tables
- 'rsbi:/Data Sources/LUW/Database/Tables/Q/'+ toupper('emp_photo')
With this formula, the path of the query is specified as rsbi:/Data Sources/LUW/Database/Tables/Q/EMP_PHOTO, where EMP_PHOTO is the name of a table.
- Formula for specifying the path for the saved procedure based on specific conditions
- 'rsbi:/.workspaces/Default/'+selection(dayname(today())=="Monday", 'script_init',
'script_end')
With this formula, the procedure gets executed only on Mondays and concludes on other days.
- Formula for using a function to derive the path of a procedure
- 'rsbi:/.workspaces/Default/'+ substr("procedure_Method", 10, 6)