I have loaded 2lis_02_hdr, itm, scl datasources in to customized cube which contains Purchasing document(EBELN), Item(EBELP), Doctype(BSART), Contract(KONNR), Item(KTPNR), Netordervalue(NETWR)
Here my requirment is I want to cummulate Netordervalue against Contract no.
In query level if I selected Purchasing doc with doctype=WK(it means it is value Contract), it is not showing any Ordervalue against Contract.
How will acheive this to get Cumulative order value against Contract.
Please share your suggestions to acheive this requirement.
For clarifications please revert back.
Thanks in Advance