Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use case statement for dashboard Prompt

Question
41
Views
0
Comments
User_C24OM
User_C24OM Rank 1 - Community Starter

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