I have a notification cube ZQM_C01 which gets the notification value of return sales document number from COPA cube in BW. In the transformation of Notification cube sales document number transformation rule has been set up as initial.
For return document number 123456, Notification # 999999 value is 20.00 in COPA cube but in Notification cube that particular document number does not exist and Notification # 999999 bringing up value of 0.00.
I checked remaining return document numbers for that day and all other return document number exist in Notificaion cube and bringing correct value but only 1 document does not appear in Notification cube.
Any ideas why this happend and how to resolved this issue?