Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert Date format MMM dd yyyy to MMMM dd yyyy

976803Oct 8 2015 — edited Oct 13 2015

Hi,

i am in FR studio 11.1.2.1.. we have a requirement to show the date in MMMM dd yyyy format which is lets say Jan 10 2015 should display as January 10 2015

Member exist in Essbase Outline: Creation Date

The member is used in the Grid and the cell value is displayed in a Text box as <<GetCell("Grid1",1,A,1)>>

I don't see the option in preference to set it as MMMM dd yyyy format which is available for system Date function <<Date("MMMM" dd yyyy)>>

I also tried with typed measures true and enable the date format but it is not working in FR report and it seems the default preference setting is taking the precedence ..

any suggestion will help..

Thanks

This post has been answered by 976803 on Oct 13 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2015

Added on Oct 8 2015

#business-intelligence-applications, #business-intelligence-foundation, #hyperion-query-and-reporting

1 comment

646 views