Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
how to implement Accouting Quarter Numbers based on Period Names
Below filter is written based on Period Number as Input prompt, but now I need to change this Period Number to Period Name, tried several ways of changing it but could not achieve.
"Fiscal Calendar"."Accounting Quarter" = case when @{PERIOD}{5} in (1,2,3) then 1 when @{PERIOD}{5} in (4,5,6) then 2 when @{PERIOD}{5} in (7,8,9) then 3 when @{PERIOD}{5} in (10,12,11) then 4 end
Expecting something like below or something which accepts Period name as input and gives Accounting Quarter as output
"Fiscal Calendar"."Accounting Quarter" = case when @SUBSTRING({PERIOD} FROM 1 FOR 3){Jul} in (’Feb’,’Mar’,’Apr’) then 1 when @SUBSTRING({PERIOD} FROM 1 FOR 3){Jul} in(’May’,’Jun’,’Jul’) then 2 when @SUBSTRING({PERIOD} FROM 1 FOR 3){Jul} in (‘Aug’,’Sep’,’Oct’) then 3 when @SUBSTRING({PERIOD} FROM 1 FOR 3){Jul} in (‘Nov’,’Dec’,’Jan’) then 4 end