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

Multi Package Prompt

Started by locus, 28 Feb 2014 05:24:18 AM

Previous topic - Next topic

locus

Hi Folks,

I have a consolidated report....5 queries, 5 pages, 5 packages.
The schemas of the packages are identical.

I want to create a single value prompt for a field that exists in each package.

To illustrate:

[PACKAGE1].[TABLE_A].[BRANCH.NR]
[PACKAGE2].[TABLE_A].[BRANCH.NR]
[PACKAGE3].[TABLE_A].[BRANCH.NR]
[PACKAGE4].[TABLE_A].[BRANCH.NR]
[PACKAGE5].[TABLE_A].[BRANCH.NR]

A lot of information on passing parameters and drill through definitions on multiple queries, but none that I could find on multiple packages.

There is a date/time range prompt which works fine, just creating ?parameter1? on the common date/time field for each query.

This does not work with the above prompt.
When creating ?parameter2? again in each case, on building the prompt you need to specify which single package you are referencing.

Is it seeing different content on each package?
Is there a way to make this prompt global?

Cheers,
Locus