Skip to Content
0
Former Member
Dec 23, 2009 at 04:07 PM

Exceptional Aggregation in Query Designer

192 Views

Hello Gurus,

we have an existing  Report at the Material Level on the InfoCube. 
Each Material may have multiple POs and we are having multiple 
records for each PO varying the date. Now the user want to view 
only the record latest changed Record at the PO level 
and Sum of all the records at the Material Level.

For this i have created a CKF using the Exception Aggregation
 as Maximum for the 0calday. But client want the Report at Material Level 
he dont want the PO's details. When i remove the PO from the report 
it gives the result for only the latest PO not all the PO for that Material.

For Example we are having below records in the cube. 

PO             Material     Calday       Qty         Price
101            ABC          1/12           100         10
101            ABC          2/12            100         10
101            ABC          3/12            100         11
102            ABC          4/12           100         10
104            ABC          5/12            100         10
103            ABC          7/12            100         11

I am getting the result with PO in Rows as Below

PO             Material     Calday       Qty         Price
101            ABC          3/12            100         11
102            ABC          4/12           100         10
104            ABC          5/12            100         10
103            ABC          7/12            100         11

When I remove the PO's From the Rows then it will display 
as below i am placing the calday for under standing the 
question actually it is not present in the  output of the below report only.

        Material     Calday       Qty         Price
          ABC         7/12          100         11

Which is not currect I have to get the Result as

Material            Qty         Price
    ABC              500         42


My Concerns:

!. Kindly let me know if it is possible and what are the 
other things that i need to consider.
2. Did it will impact the performance.

Waiting for your quick replies

Thanks & Regards

KK

Edited by: KK on Dec 23, 2009 11:08 AM

Edited by: KK on Dec 23, 2009 11:15 AM

Edited by: KK on Dec 23, 2009 11:22 AM