Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Global filtr on dashboard
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?
Answers
-
Ad 1.) Something that's usually forgotten with dashboards, prompts and filters is the option of actual dashboard filters and variables:
0 -
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?
0 -
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.
0 -
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?0 -
"NOT LIKE" not working?
0 -
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?
0 -
Not quite sure what's going on there since this works perfectly fine: Prodney / Admin123 to lon in:
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
0 -
Actually it works, I had somewhere to make a small mistake.
Thanks for the help.0 -
Cool good to know
0