Hi Guys,
I have a project using the new IBM Cognos Package, would anyone know how to pass parameters to prompt values?
IBM Cognos Package
-
- Posts: 8
- Joined: Thu Mar 03, 2011 4:01 am
- OLAP Product: Cognos TM1
- Version: 9.5
- Excel Version: 2007
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
I would love to assist, but i have no clue what you're asking of us.
-
- 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
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
-
- 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
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
-
- Posts: 8
- Joined: Thu Mar 03, 2011 4:01 am
- OLAP Product: Cognos TM1
- Version: 9.5
- Excel Version: 2007
Re: IBM Cognos Package
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.