Share
ReportI am trying to update the posted sales transactions fact table in my cube , the values comes from Navision's Value Entry Table [Sales Amount(Actual) and Cost Amount (Actual) , below is the columns in the screenshot.
I have pasted data from NAV next to my pivot as you can see in the screenshot , the budget is fine , the budget script I used to update the costs where there is FOBB (Export Costs) is
UPDATE [dbo].[Sales Budget Transactions_V] SET [Cost Amount] = ([Cost Amount] + [Sales Costs]) WHERE [Item Charge No_] = 'FOBB' UPDATE [dbo].[Sales Budget Transactions_V] SET [Sales Costs] = 0 WHERE [Item Charge No_] = 'FOBB' UPDATE [dbo].[Sales Budget Transactions_V] SET [Sales Costs FCY] = 0 WHERE [Item Charge No_] = 'FOBB'
For actuals I have copied the same budget script , however I have altered the columns according my actuals. When I add the sales amount , or sales costs , or sales costs(actuals) my data disappears in my cube report as you can see in the screenshot
My script for actuals is
UPDATE [dbo].[Posted Sales Transactions_R] SET [Sales Amount] = ([Sales Amount] + [Sales Costs (Actual)]) WHERE [Item Charge No.] = 'FOBB' UPDATE [dbo].[Posted Sales Transactions_R] SET [Sales Amount] = 0 WHERE [Item Charge No.] = 'FOBB' UPDATE [dbo].[Posted Sales Transactions_R] SET [Sales Costs FCY] = 0 WHERE [Item Charge No.] = 'FOBB'
I really don't know what I am doing wrong , and don't know how to get the data in the sales costs , sales support and actual sales amount field , where there is 'FOBB'
*This post is locked for comments
All responses (
Answers (
2,348
