Skip to Content
0
Former Member
Jun 04, 2009 at 06:22 AM

Corporate ODS Design Issue

32 Views

Hi,

I have a consolidated ods with different keys like Acc Doc No, Fiscal Year, PO No, PO Item No, Fiscal Variant etc.

In this cons ods, each Acc Doc No is UNIQUE and can have the same PO No and PO Item No.

For ex ACC DOc No is 17600001 and PO is 45000786 and PO Item is 00020

Another records is say ACC DOC NO is 17566600 and PO Is same 45000786 and PO Item is 00020. I perform certain calculations in this ODS via routined etc to calcuate po values and quantities

Now the requirement is to see report by PO and PO Item No and summing up the po value and quantites. Say 17600001 and PO is 45000786 and PO Item is 00020 has PO Val as 10000 and Qty -20

and ACC DOC NO is 17566600 and PO Is same 45000786 and PO Item is 00020 has PO Val as -1000 and Qty -10.

So i built a Corporate ODS in which I made the PO and PO Item and Fiscal Variant as the key. But in this process the same PO are overwritten and not summed for the key figures.

How can i solve the issue:

1. Do I remove the PO and PO Item as keys and make them Data field. In this process what should I make my Key (Only Fiscal Variant). Will this work??

2. Other solution

Thanks,

Hundia