Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard Prompt for custom analysis (LSQL based on subject area)
Answers
-
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).
0 -
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.
0 -
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.
0 -
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.
0 -
"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.
0 -
@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.
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
0 -
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.
1 -
"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.
1 -
@Gianni Ceresa Thank you Giann1
@Christian Berg -Oracle Thank you Christian! Those examples worked!
0