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

issue with prompts in report studio 8.4

Started by mntowe, 14 Apr 2009 03:14:15 PM

Previous topic - Next topic

mntowe

Hello,
I have a table that has vehicle information and the following fields: vehicle# and part#.

I have a prompt that gets one part number and for that part number, should get all vehicles# with the selected part. From the filtered vehicles, I'd like to have a prompt that gives me all associated parts where the user will be able to get a report with more information on those parts (from another dimension table). I've implemented it the following way:

(Query1) My first query prompts the user on one part# then gets associated vehicles#.  Have vehicle#

(Query2) My second query gets all parts# associated (I have a filter that says vehicle# in query1). Have vehicle# and Part#

(Query3) I've created a joint query on query1 and query2. The joint query should have parts associated with selected vehicles#. Joined on vehicle#, gets associated parts#

(Query4) Then I do have my report query that should prompt the user on selected parts from the join query(Query3).

This is where I'm having an issue as I get all parts on the prompt and not those associated with the selected vehicles from Query1.

I hope I did not confuse you. I cannot have a cascading prompt as I do not have a hierarchy like relationship here.

Am I doing something wrong or is there a better way to do that? Thank you.