Skip to Content
0
Former Member
Dec 05, 2006 at 01:20 PM

Deriving 0FISPER from 0DATE Using FOX or Function

54 Views

Hi,

I am trying to derive a 0FISCPER value which I need to populate on a BPS cube record. The source InfoObject is 0FINISHDATE, a 0DATE attribute on 0PM_ORDER. I have tried to do this using a FOX formula but I have not been able to strip out the year and month to reassemble them as a 0FISCPER value.

Can anyone suggest how this could be done without using an Exit.....or is an Exit my only option for this?

Thanks, Mel Waldner