nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Global filtr on dashboard

choracy69

Hi,

I have dashboard with 5 bookmarks. In most analysis I'm using Supplier Name Column.

1) Is it possible to exclude specific 20 suppliers that were not taken into account in the analysis using a global filter on the dashboard?

At this point, each single analysis used a filter as Advanced SQL Filter:

"Supplier"."Supplier Name" NOT IN ('Name','Name2', ...)

2) Second question - It is possible to constrain supplier name on prompt?

When I'm using

SELECT "Supplier"."Supplier Name" FROM "Table Name" WHERE "Supplier"."Supplier Name" = 'Name Supplier'

FETCH FIRST 65001 ROWS ONLY

Work fine, but when I want exclude some suppliers with:

SELECT "Supplier"."Supplier Name" FROM "Table Name" WHERE "Supplier"."Supplier Name" <> 'Name Supplier'

FETCH FIRST 65001 ROWS ONLY

I have error: Runtime search results are not limited to SQL result

And I have still all suppliers.

Any suggestions?

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Ad 1.) Something that's usually forgotten with dashboards, prompts and filters is the option of actual dashboard filters and variables:

choracy69

Christian thanks for response,

Ok, that I can add dashboard prompt.

In prompt can I use something like that when I want exclude one supplier from analysis?

I have another question about my second point.

Is this option has no effect on the values in the prompts?

[Deleted User]

If you reference a prompt in the dashboard options that won't affect the actual prompts used on the dashboard page but the dashboard page prompts will "win against" the dashboard property prompts so watch out that the two don't try to filter the same attribute.

choracy69

Thanks for response it's clear for me but I must test it.

The best option for me would be the exclusion of these suppliers with prompts, which applies to the second point.

Someone may know that the SQL does not work or how you can not exclude that items on the list instead choose those Someone may be available?

[Deleted User]

"NOT LIKE" not working?

choracy69

No.

I create dashboard prompt, something like that:

I use SQL formule:

SELECT "Supplier"."Supplier Name" FROM "Procurement and Spend - Purchase Orders"

WHERE "Supplier"."Supplier Name" NOT LIKE 'Supplier Name' FETCH FIRST 65001 ROWS ONLY

And when I test it on prompt and I search this supplier:

This position is further up the list. Maybe I'm doing something wrong?

[Deleted User]

Not quite sure what's going on there since this works perfectly fine: Prodney / Admin123 to lon in:

http://slc02okg.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2FPromptSQLNotLikeWorks

Works with all three variants I've tried:

SELECT "Products"."P4 Brand" FROM "A - Sample Sales" WHERE "Products"."P4 Brand" <> 'BizTech' FETCH FIRST 65001 ROWS ONLY

SELECT "Products"."P4 Brand" FROM "A - Sample Sales" WHERE "Products"."P4 Brand" NOT LIKE 'BizTech' FETCH FIRST 65001 ROWS ONLY

SELECT "Products"."P4 Brand" FROM "A - Sample Sales" WHERE "Products"."P4 Brand" NOT IN ('BizTech') FETCH FIRST 65001 ROWS ONLY

choracy69

Actually it works, I had somewhere to make a small mistake.
Thanks for the help.

[Deleted User]

Cool good to know