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

drill through from heat map not passing value

Started by Blue, 28 Aug 2017 06:07:23 PM

Previous topic - Next topic

Blue

G'day all

CA 11.0.4 on Linux (Red Hat) using DB2 10.5 data source.
Reports using Full interactive mode.

Report A contains a heat map. This has the dimensions Model Name and Unit Code and the fact Health Score.
When a user clicks a cell in the heat map a second report (B) should open in a new tab/window to display details for the selected Unit-Model combination. A model name could be "Transformer" (code = 'AAA') and a Unit code "XXX01".

Report B has three prompts. It can be accessed either directly from the Welcome page or via one of two drill throughs.
Prompt 1 is for Station Name (parent of a Unit), Model Name, and Component (Unit Model code). The first two prompts are used to filter the list displayed in the 3rd. A Station Name has the format "Xxxxxx", e.g. "Wellington" (code like "XXX"). A Model Name same as above. A Component has the form "XXX01/AAA" where XXX01 is the Unit Code as above and AAA id the Model Code.

When a user does a DT from Report A to Report B the Station Name and the Model Name get passed to the prompts just fine. But the Unit Model Code does not! The former comes from a prompt response on Report A and the latter from the Heat Map viz on Report A.  But while the Unit Model Code is in the query that drives the Heat Map it isn't in the Data Container (as it is the combination of Unit code and Model Code).

I tried using a hidden prompt on Report B to get the Unit code and then build the Unit Model code dynamically - didn't work.

I've attached a Word doc showing the settings.

Has any of you seen this problem before? Did you find a work-around?

Cheers,

Blue
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand