You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response

    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 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!