Adding fields from posted transactions to sales cube

I'm trying to add a couple fields from the sales invoice header to the sales cubes, specifically the external document field and the shipment fields (Navision calls them Shipping Agent Code and E-Ship Service Agent).

I've been able to add fields to other tables such as the customer table or item table, but I think the sales headers have been difficult because the sales data already in the cube is pulled from the invoice lines, and the fields I want to add are from the header. My efforts so far have enabled the fields to appear in the Pivot Table list when I'm using the cubes in Excel, however when I create I filter sales data based on an aspect of these fields, it comes up with some sales but not all of them, almost at random.

Are there any tricks to syncing the aspects of the headers to the sales data?

1 comment

Please sign in to leave a comment.