cancel
Showing results for 
Search instead for 
Did you mean: 

variables in web intelligence

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Could you explain with more clarity on what you are trying to achieve?

Jacques

Former Member
0 Kudos

in SQL...

where... campA like '1.1.2.%' in create variable in BO XI R2 is possible???

Edited by: gzofera on Oct 6, 2008 8:02 PM

Former Member
0 Kudos

The "like" function in SQL is achieved using the "match" function in WebI. To get more on match, look at the on-line Help Guides.

Former Member
0 Kudos

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

Former Member
0 Kudos

i tried i did nothing, what are these "match" functions

Former Member
0 Kudos

OKS MY FRIEND

thank's

Answers (0)