Year Month to Month

[former_member193552]

I have BW Query that has "Calendar Year/Month" Jan 2014, Feb  2014  etc... Now I want to extract Month from it in query as dimension... is that possible?.

[amitrathi239]

Hi,

Use Substr function in webi to extract only month name.

=substr[month];1;3)

[former_member4998]

Hi..

You can do at different level

@ universe level- You can define using  predefined function TO_CHAR or Use the custom display format option. Please find the below link.

http://scn.sap.com/community/semantic-layer/blog/2014/04/18/bi41-business-layer-enhancements--create...

@ WebI Rich Client - You can use predefined functions

@ BW Query level - As per the best practice, you can define at  bex query,

so this object automatically available in the WebI.