Presentation variable and left function

Question

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

Robert Angel · Answer

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?

Robert Angel · Answer

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

asim cholas · Answer

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