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

Cascade from 2, or more, Parameters

Started by Cognos_Jan2017, 14 Jun 2017 12:25:13 PM

Previous topic - Next topic

Cognos_Jan2017

Included on an existing Prompt Page are ...

Prompt_Level1  -  Parameter Level1
Prompt_Level2  -  Parameter Level2 - Cascade of Level1

Example ..
Level1 has entries of ...
AAA
BBB
CCC

Our current Value Prompt for Locations
is based on Locations from the Cascade of Level1
selections of AAA, BBB, and CCC

Level2 has entries which Cascade from Level1 selections like ...
   Parent  Children
   AAA     Asia Pacific
              North America
         South America
   BBB     Asia Pacific
         North America
         Europe
   CCC     Asia Pacific
         North America

How would we set a Cascade for Locations when both Level1 and Level2
have entries, IE ...               
See Locations Only from ...
Parent    Children               
AAA       Asia Pacific               
             North America

TIA, Bob

dougp

Place value prompt 3 on a downstream prompt page and don't make it a cascade target.  The query for value prompt 3 should include filters that use parameter 1 and parameter 2.

Cognos_Jan2017

Thank you.

Not sure what downstream prompt page is?

As a relatively new Report Author (Jan 2017), I will try
this and report back to this thread hopefully tomorrow.

I am fortunate to have several Report requirements at
the same time.

Cognos_Jan2017

The existing Prompt Page does list 'Level2Locations' properly
as a Cascade from Level2 which cascades from Level1

Is it possible to "detect" which Filter to run based on whether
Level1 or Level2 Locations are selected?

Existing Detail Filter is ...
[Location Code] In ?OneLevelLocations?
which are the Locations selected from the
Cascade of Level1

The second parameter is ...
Level2Locations

TIA, Bob

dougp

"Downstream" prompt page:  Add a prompt page after the first prompt page.

Cognos_Jan2017

Thank you.

Will continue trying to put this all together.