Hopefully someone can help
I have a TI process that gets data from a SQL database
I had parameterised the SQL to be the following
select * from RefFrontlistTitles where globaldivision = '?p0?'
and on the PROLOG I have the following
p0=CellGetS('RFC - Control','Password','Value');
Within the Cube - 'RFC - Control' the intersection of Password and Value is 'ACAD'
When I try to Preview it now doesn't apply the where clause
This worked until I moved TM1 to a new Virtual Server and now none of the params are getting passed to the SQL
I have tested the CellGetS within a variable and it returns the correct value of 'ACAD'
Any help greatly appreciated