Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

java 1.5

replied

Hi,

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

Jacques

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question