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

Can't set variable to read Fact/data item values

Started by dfite, 04 Sep 2007 02:36:44 PM

Previous topic - Next topic

dfite

I am fairly new, so please forgive if this is a stupid question, but how do you set a variable to reflect the value of a query's fact?  I am trying to conditionally display text based on the contents of a query fact, but the variable always returns a "no" result.  I create a new variable, and set its expression to [TIER]= '3', then create a conditional block and set its Conditional Block preperty to use my new variable and the Current Block property to Yes.  The test never displays, even when the query's TIER fact is equal to 3.  Any ideas?

MFGF

Hi,

Just checking - what kind of variable did you define - Boolean or String?  Assuming it's Boolean, can you check that [Tier] is a character value, not a number (ie that your expression should not be [Tier] = 3)

Just a thought,

MF.
Meep!

COGNOiSe administrator


MDXpressor

Additionally, if it is a String Variable, you need to define the values you are going to use to the list of values in the Variable Explorer.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien