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

Multiple variables from one prompt

Started by browni, 14 May 2008 04:56:59 PM

Previous topic - Next topic

browni

Currently we have a tree prompt returning a variable based on the companies dimension and representing either the group level or subsidiary level companies.  The item returned in the prompt variable can be used to calculate the level in the hierarchy to determine whether intra-group accounts should be eliminated because the report is being run at the group level.  However, we have been unable to use the variable based on the companies dimension in a conditional calculation based on the accounts dimension without the report failing.  Consequently, we have had to implement a second prompt with Yes/No static choices as the basis for performing the conditional calculation based on the accounts dimension.

This additional Yes/No prompt seems unnecessary and we would like to remove it if possible.  Is there any way to create a second variable without the user needing to make a second prompt choice?

Thanks in advance.

raro

Could imagine that passing the var via URL like htp://.../servlet/dispatch?...p_mysecondvar=yes
could be a choice. If you can pass it on to the report via URL, you are also able to manipulate the URL to be submitted via JAvaScript within the prompt page.

Let me know if this solved your question.