COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: darners on 09 Mar 2016 10:03:50 AM

Title: TI Process parameters
Post by: darners on 09 Mar 2016 10:03:50 AM
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