Question Re: How to implement like function in bods? in Technology Q&A

How to implement like function in bods?

Former Member — Fri, 28 Jun 2019 10:33:32 GMT

How to implement like function in bods?

Re: How to implement like function in bods?

Toby_Johnston1 — Fri, 28 Jun 2019 13:36:06 GMT

Hi Reddy,

If you mean to run a Landscape Analysis Report, you can use it against your IPS landscape as it is essentially a BI Platform with specific plugins for Data Services. Some analysis types won't be available against IPS but the core functionality such as Server & Services Analysis, Patch History, etc can be reported on.

Let me know if that doesn't answer your question

Thanks
Toby

Re: How to implement like function in bods?

denis_konovalov — Mon, 01 Jul 2019 12:31:54 GMT

I have fixed your tag. Please do not select randomly as your questions will not be seen by correct audience.

Re: How to implement like function in bods?

werner_daehn — Tue, 02 Jul 2019 06:09:52 GMT

I read the question as "Is there a 'like' operator in Data Services similar to SQL?".

Yes: https://help.sap.com/viewer/8092b085a68941f6aaa6708685a62b0d/4.2.11/en-US/576c21606d6d1014b3fc9283b0e91070.html

Example: The mapping of a column could be

ifthenelse(gender like 'f%', 'female', 'not female')

I know the Operators are listed in the docs under the chapter Scripting but the same syntax can be used in mappings and where clauses also.