Oracle Communities

Oracle Analytics and AI

Child Item

Alternative to OBIEE SQL Expression filter.

In OBIEE classic, I use SQL Expression in filter. It is very useful to filter out the columns data.

Image is like below.

But in OAC , we don't have this option. Workaround/ Solution for this is Parameter with Logical SQL. But OAC Viz is showing listing only 1000. Please see below image. Where as OBIEE SQL expression will filter all values. Please see image.

Is there any workaround to achieve to bind complete list of value selected automatically.? or any alternate solution.?

Find more posts tagged with

Accepted answers

All comments

Steve F-2

I thought back in the September 2023 update this limit was increased; however, having said that what is the exact use-case / flow / how you use it? Do you really want a user to select thousands of ID's?

Which viz are you displaying in the background of the screenshot?

Maybe we can understand that part better.

The "classic" selection steps is also on the roadmap (different use-case).

@Avinash Krishnaram-Oracle - Appreciate if you have any comments here.

Rajakumar Burra

@SteveF-Oracle Before September 2023 update @Avinash Krishnaram-Oracle informed us about increase of limit. But never happened.

Regarding use case:

We have different use cases. We have multiple products and multiple supported versions. One bug required to fix in multiple products as well as multiple versions.

For example Bug ID A1 have tasks of

Product X , Version X1
Product X , Version X2
Product X , Version X3
Product Y, Version Y1
Product Y , Version Y2

So we use SQL Expression filter or Logical SQL Parameter to get the Bugs fixed in Product X & Version X1.

Then we find the pending tasks of such bugs. When we search for our enterprise products, we will have 1000+ bugs.

I tuned my filters such way that very rare case we come across above 1000.

But today we got such case in Enterprise license subscription users list where we want to find common users of instance to other instance of Enterprise subscription. Here I didn't find anyway of filters.

Avinash Krishnaram-Oracle

Hello,

Possible values limit is increased to 10,000.

Initial values is still limited to 1000 - and this was to safeguard the workbook performance at initial load when executing parameter values.

It looks like the current value of parameter is also limited to 1000 (again as a guardrail for performance). I will discuss with my engineering team on the feasibility to increase the current value limits.

Thanks.

Rajakumar Burra

@Avinash Krishnaram-Oracle What is the solution for now. I can't use Parameters and we don't have option of column level SQL filter. Current my query output is with 1279 unique email ids which is beyond 1000 limit.

Surprisingly , you reply is marked as "Best Answer" and status of question is marked as "Answer Accepted".

Strange policy of Oracle community. How can question marked as "Accepted" without reporter consent.

Benjamin Arnulf-Oracle

Hi Rajakumar, I removed the accepted answer. Remember to use the "Flag" option on a post to report to a moderator or admin.

Avinash Krishnaram-Oracle

@Rajakumar Burra The status change was done by a colleague by mistake. Accept our apologies. Our goal as a collective team is to help our customers.

I do not have a workaround for your use case. I have engaged with engineering teams for

workaround
to increase limits on current value - like i said, this limit is enforced as a guardrail for performance.

Thanks

Avinash

Avinash Krishnaram-Oracle

A bug has been logged for the engineering team to increase the current value limits.

Thanks

Avinash

Rajakumar Burra

@Avinash Krishnaram-Oracle @Gabby Rubin-Oracle We badly need to increase of display values of Parameters results or need solution of SQL expression filters.

In OBIEE Classic , it is easy to filter the data through SQL expressions which is missing in OAC . Currently we are using logical expression through parameters. But parameters bounding restriction is up to 1000 results only.

If you enhance the Expression filters to use of SQL Expression filters will be great useful feature.