Solved

Is there an equivalent to the "Like" operator in Business Objects XI

Posted on 2009-05-06
2
5,966 Views
Last Modified: 2013-11-15
I have a table in a Desktop Intelligence report which pulls from multiple data providers. I want to add a column to the report table which uses an IF...THEN statement to test for a value in one of the report objects. For example: IF <Operating As Name> like "%OCC%" then 0 else 1

I get an error message with this syntax. I've also tried using the MATCH function but I'm not getting the results I expect. I appreciate any ideas!

Thanks!
David
0
Comment
Question by:dking_wri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
by6738 earned 500 total points
ID: 24319903
you'll want to use MATCH.  Perhaps your syntax was incorrect?  It should be similiar to:

if Match("asdf","%sd%") Then "Match Found" else "No Match Found"
0
 

Author Comment

by:dking_wri
ID: 24320481
Thanks for your tip. I'm not sure why I can't get MATCH() to work. This is the syntax I'm using but it isn't returning 0 for the record that contains the string "OCC". It returns the defaul value of 1
=if match( <Operating As Name(Annual Rents)> , "%OCC%")  then 0 else 1


I found that the POS() function does work for me. I used the syntax:  =if pos(<Operating As Name(Annual Rents)>, "OCC") = 0 then 0 else 1

If the Position function doesn't find the input string then it return 0 else it returns 1.  
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question