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