Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 184 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to use case statement for dashboard Prompt

Hi All,
We have 2 dashboard Prompt 1. Business unit = and 2. Manager.
When users Select the BUSINESS UNIT = STEEL dropdown value from the dashboard prompt, then Manager prompt value should be restricted with Regional Manager Role
I created a report using analysis and the same SQL logic I used in Dashboard prompt it's not working.
Analysis logic
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Marketing - CRM Leads"."Employee"."Manager of Employee" s_1
FROM "Marketing - CRM Leads"
WHERE
((DESCRIPTOR_IDOF("Marketing - CRM Leads"."Business Unit"."Business Unit Name") = 'STEEL') AND ("Resource Hierarchy"."Current Level 13 Position" = 'Regional Manager'))
ORDER BY 1, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY
When I applied the same logic I was getting the error as Failed to load(Odbc driver returned an error (SQLExecDirectW).)
Manager Prompt Logic I wrote like this
CASE WHEN "Business Unit"."Business Unit Name" = 'STEEL' AND "Resource Hierarchy"."Current Level 13 Position" = 'WI Regional Manager' THEN "Employee"."Manager of Employee" END
Can anyone check is my logic is correct or wrong. Or how best we can achieve this scenario