Skip to Content
0
Former Member
Jun 25, 2009 at 03:07 PM

How to enter reason in real time cube.

36 Views

Dear All,

I have to following requirement, in the real time cube we have the plan and actual data and I want to stamp the reason against the record.

If (actual >= plan) then

Reason = plan meet.

Else

Reason = Plan Not Meet

End if.

Material Reason Plan Qty Actual

cnree100 PlanMeet 10 18

pawa100 Plan Not Meet 23 20

chris100 PlanMeet 454 460

How to read record by record and update the reason for the given filter

How to achieve these using IP u2013 Fox formula.

How to fetch plan qty and actual qty in in Fox Formula.

Thanks

Christopher