Presentation variable and left function

48d95e02-1a68-4e67-acad-79e66af6b059 · Aug 29, 2017 6:14AM

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 · Aug 29, 2017 7:44AM

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

Robert Angel · Aug 29, 2017 8:08AM

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

Robert Angel · Aug 30, 2017 5:06AM

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?

Oracle Analytics Cloud and Server