Dashboard Prompt for custom analysis (LSQL based on subject area)

Gianni Ceresa

Is your prompt a real number? Or is that a number but defined as text?

And is "Person_Number" the real name of the column? As you can see from the query visible in the error, what the tool is doing is adding the filters conditions to the LSQL of your analysis. You must make sure that the column is correctly referenced.

That's my guess seeing the error, then you can of course look at the whole query and figure out what is the error in there (you can execute it directly against the BI Server to test it and find the valid syntax if needed).

Sa_De_Or

Hi @Gianni Ceresa,

the prompt is a string. Person Number is a alphanumeric value.

I have tried "Workforce Management - Worker Assignment Real Time"."Worker"."Person Number", "Worker"."Person Number" , "Person Number" and Person_Number and C.s_6.

Unfortunately, this didn't work.

[Deleted User]

If it's an alphanumeric string then it's a string and not a number.

Your presentation variable is a number. Make it a string and you should be peachy.

'@{pvStringNotNumber}{123}'

That will make 123 be technically a string: '123'

Data type consistency must be observed.

Sa_De_Or

Hi Christian,

thank you for this. I have tried your solution and it still does not seem to work.

Before I tried with the {-999} . Both variants did not work. I get the same error as above.

[Deleted User]

"does not seem to work"

What does that mean? What does the log file say? What is the exact error? What you are asking is basic standard functionality and works normally, so there must be an issue with either your data or with how you have set up things.

If you do not provide clear details on what is happening this can not be resolved.

Gokul

@Gianni Ceresa @Christian Berg -Oracle

Hi team,

If the presentation variable is configured to allow multi-select and if the data type is string this would still not work correct? Because the application would pass to the criteria the value as a list of strings comma separated without quotes.

@Sa_De_Or

https://community.oracle.com/products/oracleanalytics/discussion/comment/25692#Comment_25692?utm_source=community-search&utm_medium=organic-search&utm_term=dashboard+string+prompt+multi-select

Gianni Ceresa

You could try with this kind of format: @{pv_select_value}['@']

I didn't test it, but it should give a list of quoted values of the variable, therefore it will work.

[Deleted User]

"Dimension"."Attribute" in (@{pv_My_Var}['@']{"Dimension"."Attribute"})

"Region"."Country" in (@{pv_My_Var}['@']{'Germany'})

This is a syntax example for multi valued presentation variable referencing with a default value.

Gokul

@Gianni Ceresa Thank you Giann1

@Christian Berg -Oracle Thank you Christian! Those examples worked!