Capturing multiple string value in a presentation variable

Saro · Oct 17, 2017 4:01AM

Hi friends,

Im in obiee 11g. In my scenario i have a prompt called period and it is of multi-select

If i select multiple values, then the values will pass like JAN-17;FEB-17;MAR-17 etc.

Is it possible to capture the above string value(JAN-17;FEB-17;MAR-17) in a presentation variable.

Because i tried like (@{v_period}['@']) but this syntax dint work.

How to capture the entire string values(i.e) (JAN-17;FEB-17;MAR-17) in a presentation variable

Thanks in advance.

Regards,

Saro

Gianni Ceresa · Oct 17, 2017 4:13AM

Hi,

If you set your prompt to also store the selected values in a presentation variable it will just do it by itself. The variable will have all the selected values.

So isn't your issue more on "how to use that variable with multiple values" instead of how to capture the multiple values in a variable?

Joel · Oct 17, 2017 4:14AM

Can you try this: ('@{v_period}['@']')

asim cholas · Oct 17, 2017 4:15AM

Hello Saro

This is will not work until the late editions of 11g. and it works fine from then. So which is your obiee version.

OBIEE 11G: Error: "[nQSError: 27005] Unresolved column: saw_0 (HY000)" When Populating a Variable Prompt with a SQL Statement (Doc ID 1345964.1)

Passing multiple values to a presentation variable

There seems to be workaround for this issue and it is explained in several blogs(though i havnt tried)

[Deleted User] · Oct 17, 2017 4:25AM

@{v_period}{some sting} automaticall captures multi-value and outputs it as 2014,2015,2016,2017

And filters also accept that. You can just say "is prompted" and it will work. It's all default functionality.

asim cholas · Oct 17, 2017 4:27AM

When it is assigned in column formula, it used to pass like below.

case when MonthYear in('Jan-2014,Feb-2015,Mar-2016,Apr-2017') then ... end instead of

case when MonthYear in('Jan-2014','Feb-2015','Mar-2016','Apr-2017') then ... end

[Deleted User] · Oct 17, 2017 4:34AM

Yes, but is that the question of the OP? He just asks for the string in a variable and does not specify any usage.

In any case if itßs your use case then it points most probably to an improper usage of the solution

asim cholas · Oct 17, 2017 4:36AM

Even if we apply the presentation variable in common filters it will work with multiple values. But when it is used inside a column formula it will not.

Seems like he is searching for this.

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1418868_1.htm…

[Deleted User] · Oct 17, 2017 4:43AM

If it's that it's high time to upgrade since it was fixed a long time ago

Saro · Oct 17, 2017 4:43AM

Hi Gianni,

If you set your prompt to also store the selected values in a presentation variable it will just do it by itself. The variable will have all the selected values.

Yes i have a presentation variable assigned to the column period called v_period.

What im trying to do is, suppose if i select multiple values in my prompt like JAN-17;FEB-17;MAR-17

Im trying to get the last month name alone from the above string using the below expression like

substring(@{v_period} from -6 for 3) inorder to get MAR, but this is not working.

Since my selection of multiple values will be dynamic, so whatever the multi-period i select, i need to get the last month name alone from the string.

Thanks,

Saro

[Deleted User] · Oct 17, 2017 4:46AM

Saro wrote:Im trying to get the last month name alone from the above string using the below expression like

Ok so this is a totally different issue than what you stated above so let's make things clear:

Is this REALLY what you are after or with the next answer it will become yet another thing that you're trying to do?

#beprecise

Oracle Analytics Cloud and Server

Categories

Capturing multiple string value in a presentation variable

Answers