Cal.Year/ Month - Applet - MM.YYYY and HTML- MMM.YYYY

[former_member4998]

Hi All.

I have created Webi Report on top of Bex Query. 

While running the webi report Cal.Year/ Month Prompts list of vales showing format as MM.YYYY (01.2014) in Applet version.

and running the same report with HTML version, Cal.Year/ Month Prompts list of vales showing different format as MMM.YYYY (Jan.2014).

I have checked at bex Q level Cal.Year/ Month variable have List of values MM.YYYY (01.2014) format.

Cal.Year/ Month - @

Bex Q : MM YYYY

Applet - MM.YYYY  

HTML- MMM.YYYY

Need to understand same report Cal.Year/ Month Prompts list of vales showing  different format (Applet - MM.YYYY. HTML- MMM.YYYY).

is there any way to fix the issue display same format in the both version.

[sateesh_kumar1]

Hi Sreeni ,

Are you using Unv /BICS ?

Did you checked both applet and HTML version with the same user ?

HTML and Applet version report pointed to same BO and BW system ?

In BEx , variable values shows both text and key and when value selected it only show key in the entry field box .

[former_member4998]

Hi Sateesh,

Thanks for reply.

Are you using Unv /BICS ?  BICS

Did you checked both applet and HTML version with the same user ? Yes, Same user

HTML and Applet version report pointed to same BO and BW system ? Yes, Both BO and BW systems are same. (development systems)

In BEx , variable values shows both text and key and when value selected it only show key in the entry field box .- Yes, bex variable and characteristic defined display as KEY.

I have created Cal.Year/ Month Prompts at webi level….while refresh the report. Cal.Year/ Month Prompts  list of vales showing  different format (Applet -MM.YYYY (01.2014). HTML- MMM.YYYY (Jan.2014)).

[sateesh_kumar1]

Which object you selected for LOV's ?

Use L01 Calendar Month/Year ,make sure calendar month/year key is assigned for Index in Keys tab of object properties.

Which version of BO you are using ?

[former_member211235]

Even though it is in MM.YYYY in applet mode, I suggest you to try placing the formula FormatDate(Date object) at WebI level and check.

Grtz

-Anila.

[former_member4998]

Thanks for the reply.

I Need to understand same report Cal.Year/ Month Prompts list of vales showing  different format (Applet -MM.YYYY. HTML- MMM.YYYY).

is there any way to fix the issue, to  display same format at prompt list values in the both version.