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

Important discovery about Cascading Prompts

Started by morphy, 18 Dec 2008 01:23:15 AM

Previous topic - Next topic

morphy

Hi all,

Still fighting against cascading prompts...hehe...
but now I made an important discovery.

I create a cascading prompt in this way (as u all suggested me):

--Drag&Drop a value prompt on a prompt page;
--Create a New Parameter;
--Select the proper Package Item...
And the issue is properly at this point, when selecting a Package Item.

I realized that if the Data (Columns) of the Report come from the same Package Items, everything works.
For example, the data in the Report are:
OBJECT   CLASS   ORGANIZATION (All from R5OBJECTS Package Item)
and then I select ORGANIZATION for the Cascading Prompt from the same Package Item, the cascading prompt works!

But if the Data of the Report come from a Query that I wrote (even with the same data: SELECT OBJECT, CLASS, ORGANIZATION FROM R5OBJECTS), but I choose ORGANIZATION from the R5OBJECTS Package, the Cascading Prompt does not work!!!

Maybe i have not been clear but this is how it works!

So what is the solution?

How can I create working Cascading Prompts when my Data in the Report are not selected from the Package Items but from my Queries???

Thanks in Advance.

Ciao

Matty