Oracle Analytics Cloud and Server

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

Parameters Failed to Load on BIP Using List of Value

Received Response
51
Views
5
Comments

Content

Please help , Parameters are not loading whenever the rows exceeds more than 200 in List of values.

1.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 4 - Community Specialist

    Hi Atif, just a little further information - please could you upload a screenshot of the Parameters selection as well?

  • Rank 2 - Community Beginner

    Please see the attached screen shots

    2.png

  • Rank 6 - Analytics Lead

    Hi Atif.

    I'm assuming the SQL Query works fine when running in SQL Developer or other SQL tool right?

    Are you able to click on "View Data" and then "View Engine Log" and upload to the thread so we can investigate a little better. Please, if you want to remove any sensitive information from the log (server name, etc...), do so.

    Cheers.

    Fernando

  • Rank 2 - Community Beginner

    Dear Fernando , 

    Yes the Query for "List of Value" works fine when we execute it separately.  Actually I noticed that it works fine if i limit the number of rows in "List of value" to be 200.

    If more than 200 rows then parameters doesn't load appropriately. 

     

  • Rank 2 - Community Beginner

    Dear Fernando , 

    Yes the Query for "List of Value" works fine when we execute it separately.  Actually I noticed that it works fine if i limit the number of rows in "List of value" to be 200.

    If more than 200 rows then parameters doesn't load appropriately. 

Welcome!

It looks like you're new here. Sign in or register to get started.