variables in web intelligence
how to use the command like in time to create variables on Web intelligence? or any command that has the same function. because i have the following demand ... i have to take "1.1. 1.2%" someone has done something like this?
P.S: BO XI R2
Windows server 2003 SP4
Jacques du Preez replied
You can use the Match function.
Match([Country];"F*") returns True if [Country} is "France"
Match([Country];"?S?") returns True if [Country] is "USA"
Match("New York";"P*") returns False
The pattern can contain the wildcards "*" (replaces any set of characters) or "?" (replaces any single character)
You also need to note that the data type needs to be of type "string".
Further you can use the IF statement as the match function just returns a True or False... i.e IF MATCH is true THEN x ELSE y..
Hope this helps