Hi,
I've created a dimension under JDM based on the dimension that is used in some companies of my NAV DB (it's not a global dimension).
The problem is that I don't know what to do when there is a company that don't use this dimension. Now JDM tries to migrate all data and when there's a row without this dimension it informs me that there's an error: 'Violation of foreign key constraint - record (DW_Account), (Entry(No.)) not found in table (dbo).(NAV_dbo_Ledger Entry Dimension_V).
I'm sorry if my post isn't clear, but I'm not an IT guy and JDM is something new for me:)
If there's some documentation that I should post also, please let me know what should it be.
Thank's!
Tomek
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Tomek,
The relationship between the Item Ledger Entry table and the Value Entry table should probably be set as a "relationship", not a "restriction". If you open up the staging database and go down to the Value Entry table and open it you will see a relationship at the bottom (there will be a picture of a link and it will say "NAV_dbo_Item Ledger Entry"). Right click on that, click on Relationship Type, and make sure that it's set to "Relationship".
One more thing to note when adding things in such as fields or lookups is that it is always pertinent (especially when you have multiple companies!) to add in the "DW_Account = DW_Account" (in some cases it's called "Company", such as in the data warehouse, but they are the same) join. This will ensure that when it is pulling in data from another table that it also matches it up by company. Otherwise you could try to bring in, say, the Salesperson Code for Invoice 10000 but without this link for company it is possible that it will bring in the Salesperson Code for the same document number but from the wrong company.
Please sign in to leave a comment.