Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
160
Views
19
Comments
2»

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).

  • Sa_De_Or
    Sa_De_Or Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 7 - Analytics Coach

    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
    Sa_De_Or Rank 3 - Community Apprentice

    Hi Christian,

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

    image.png

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

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    "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
    Gokul Rank 1 - Community Starter
    edited Oct 9, 2024 5:35PM

    @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

  • 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]
    [Deleted User] Rank 7 - Analytics Coach
    "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
    Gokul Rank 1 - Community Starter

    @Gianni Ceresa Thank you Giann1

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