IBM Cognos Package

Post Reply
michael.cajucom
Posts: 8
Joined: Thu Mar 03, 2011 4:01 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2007

IBM Cognos Package

Post 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?
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: IBM Cognos Package

Post 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??
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
ellissj3
Posts: 54
Joined: Tue Jun 15, 2010 1:43 pm
OLAP Product: Cognos TM1
Version: 9.0 - 10.2
Excel Version: 2010

Re: IBM Cognos Package

Post by ellissj3 »

I would love to assist, but i have no clue what you're asking of us.
Andy Key
MVP
Posts: 352
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: IBM Cognos Package

Post 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.
Andy Key
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: IBM Cognos Package

Post 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
michael.cajucom
Posts: 8
Joined: Thu Mar 03, 2011 4:01 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2007

Re: IBM Cognos Package

Post 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.
Post Reply