Presentation variable and left function

48d95e02-1a68-4e67-acad-79e66af6b059

Hello to all,

How can I run a string function like "left" to extract only a few large ones from a slash-by-slice presentation?

For example, I wrote the following:

                                                        "FL_L_IN_SAP". "PARTITION_KEY" IN ('ERP _ @ {LEFT (PartitionEntity, 6)} ....

But without success.

Thanks a lot to everyone,

Livio

asim cholas

Please provide an example , so that people will understand better.

Robert Angel

You need to use the substring function, in conjunction with the locate function, see below for a very similar question =>

Alternative for INSTR() in OBIEE

Robert Angel

Hi,

on your slice by slice the only other point is to move your generated value to a page or prompt level.

Do you still have an issue?