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?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello,
Since the data that you are looking to get into the Sales cube is related to the sales documents as a whole I would take the approach of adding the fields to the Sales Header (which it sounds like you have already done) and then dragging these up to the Sales Document table in the data warehouse. You can then add these as new dimension levels to the Sales Document dimension on the cubes tab. Once everything is processed you will be able to pull these into the report or filter on them.
I hope that this helps!
Please sign in to leave a comment.