Month Number to Month Name in Universe

[former_member203168]

Hi,

I have created a Universe based on BEx query in UDT.

We have a Fiscal Period object in query, which is giving period values in characters.

We want to convert those periods to Month names, I have used below syntax but giving me parsing error.

=if([0FISCPER3].[LEVEL01]=1;Jan;if([0FISCPER3].[LEVEL01]=2;Feb;if([0FISCPER3].[LEVEL01]=3;Mar;if([0FISCPER3].[LEVEL01]=4;Apr;if([0FISCPER3].[LEVEL01]=5;May;if([0FISCPER3].[LEVEL01]=6;June;if([0FISCPER3].[LEVEL01]=7;July;if([0FISCPER3].[LEVEL01]=8;Aug;if([0FISCPER3].[LEVEL01]=9;Sep;if([0FISCPER3].[LEVEL01]=10;Oct;if([0FISCPER3].[LEVEL01]=11;Nov;Dec)))))))))))

Please suggest me.

--Praveen G

[former_member4998]

Hi

You need to use CASE statement…below is the sample code

CASE WHEN

[0FISCPER3].[LEVEL01]= '1'

THEN ' Jan'

WHEN [0FISCPER3].[LEVEL01]= '1'

THEN 'Feb'

WHEN [0FISCPER3].[LEVEL01]= '1'

THEN 'March'

END

[former_member203168]

Hi,

Getting below error message when I use Case or If condition in Select clause.

--Praveen G

[former_member678295]

Praveen,

Please check SYNTAX.

What happened to ELSE?

[former_member203168]

Hi,

I have created an object and inserted below logic,

<EXPRESSION>
IIF(@Select(Posting period\L01 Posting period)=1,1,2)
</EXPRESSION>

But it is always giving 2 only,i.e., else case value for all periods.

--Praveen G

[former_member678295]

Hello Praveen,

You are correct. The above logic is in correct.. Use "case" .

CASE expression

   WHEN value_1 THEN result_1

   WHEN value_2 THEN result_2

   ...

   WHEN value_n THEN result_n

   ELSE result

END