Tag Archives: DatasourceNameForServer

DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax

Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process so it becomes dynamic? Well here is a method. Firstly, define a bunch of variables: sCurrentMonth = CellGetS ( ‘System Assumptions’, ‘No Year’, ‘No Month’, ‘Current Month’, ‘String’ ); sFileDir = ‘\\servername\folder\’; sFileName = sCurrentMonth | ‘ ‘ | SUBST(sCurrentYear,3,2) | ‘ Employees.csv’; sFilePath = sFileDir | sFileName; Then use DatasourceNameForServer and DatasourceNameForClient to … Continue Reading

This entry was posted in TI Data Sources, TI Functions, TI Processes and tagged CellGetS, DatasourceNameForClient, DatasourceNameForServer, SubSt. Bookmark the permalink. | Tagged CellGetS, DatasourceNameForClient, DatasourceNameForServer, SubSt | Leave a comment