If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

TI Process parameters

Started by darners, 09 Mar 2016 10:03:50 AM

Previous topic - Next topic

darners

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