Page 1 of 1

IBM Cognos Package

Posted: Wed Apr 27, 2011 9:55 am
by michael.cajucom
Hi Guys,
I have a project using the new IBM Cognos Package, would anyone know how to pass parameters to prompt values?

Re: IBM Cognos Package

Posted: Wed Apr 27, 2011 2:20 pm
by jim wood
I think you need to be a little more specific than that. Which Cognos package are you talking about? Passing from what to what??

Re: IBM Cognos Package

Posted: Wed Apr 27, 2011 5:22 pm
by ellissj3
I would love to assist, but i have no clue what you're asking of us.

Re: IBM Cognos Package

Posted: Thu Apr 28, 2011 12:15 am
by Andy Key
I assume you are using the Package Connector as a data source for a TI process, so as the only supported source for a Framework Manager Package through the Package Connector is SAP, do the old TI DataSourceSAP variables work? If so, you may be able to use AddInfoCubeRestriction.

Re: IBM Cognos Package

Posted: Thu Apr 28, 2011 2:37 am
by PlanningDev
I'm confused. Are you saying that the only supported datasource for a package is SAP? I have multiple dimensions and cubes that use a package built on Teradata. Are you asking how to pass parameters into the TI that will fill the prompt values in your FM package? I haven't had to do this yet but I was reading the guide on how to pass values to the prompts and will see if I find anything

Re: IBM Cognos Package

Posted: Thu Apr 28, 2011 2:45 am
by michael.cajucom
From Turbo Integrator Data Source is IBM Cognos Package, we have a saved query from BEX that is package in Framework manager. The query includes prompts to limit the return value of the query (example by year and month). From the Turbo Integrator there is a command button that you click and a dialog box appears that lets you input the prompts needed. Is there a way to automatically pass values for this because we want to schedule this and run the turbo integrator process monthly.