How Can I display Period in Dynamic?

[Former Member]

Hi,

I have an issue in BO reports. Actually, I have an object in universe like, [Period] having P01...P13. But, i want to show in report header like P1, P2, P3..etc

I can able to write sql query in oracle like, DECODE(SUBSTR([period],2,1),0,REPLACE([period],'0',''),[period])

how can i write in business objects?

[Former Member · Accepted solution]

Hi,

Try the below logic:

If(substr([Period];2;1)="0";Replace([Period];"0";"");[Period])

If(Length([Period]=2;Left([Period],1)+'0'+Right([Period],1);[Period])

[former_member51282 · Accepted solution]

Hi,

I am moving this discussion to the Business Intelligence section as not training related. Regars, Arnold