Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Parameters Failed to Load on BIP Using List of Value

Content
Please help , Parameters are not loading whenever the rows exceeds more than 200 in List of values.
Answers
-
Hi Atif, just a little further information - please could you upload a screenshot of the Parameters selection as well?
0 -
Please see the attached screen shots
0 -
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
0 -
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.
0 -
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.
0