LPL Columnar Aggregation Table

dsimpson

I was able to successfully get a list view to summarize vendor spend on the PayablesInvoice business class using "implements ColumnarView" and this code:

Charts

    SpendByVendor is an AggregationTable

        chart list

        is default

        show totals first

        Dimensions

            Vendor 

            DerivedVendorName

                label is "VendorName"

            InvoiceVendorAddressRel.PostalAddress.DeliveryAddress.AddressLine1

                label is "Street"

            InvoiceVendorAddressRel.PostalAddress.Municipality

                label is "City"

            InvoiceVendorAddressRel.PostalAddress.StateProvince

                label is "ST"

            InvoiceVendorAddressRel.PostalAddress.PostalCode

                label is "Zip"


            InvoiceCurrency

                label is "Currency"


        Measures

            sum InvoiceAmount.CurrencyAmount

                label is "Total"

                is default sort order descending

And after adding fields to the replication set and rebuilding the cube for AP, it produces expected results - a summary one line for each vendor, the address, and a total amount.

I am attempting to do the same thing (or something similar) on the PayablesInvoicePayment business class; however the Measures value for

sum NetPaymentAmount.CurrencyAmount returns zeros rather than the amount. This is the field referenced in Payables > Payments > Vendor Payment (

VendorPaymentHistoryList). Any assistance would be appreciated.