Trouble matching data seen in AX client to database entries

(0) Share

Report

Posted on by Community Member

Hi,

So i'm using this technote to match data and configurations to the entities and database entries but they dont seem to match up. For example, under Human Resources - Employees i have over 100 employees but if i look at the table DMFEmployeeEntity, there is only 1 entry. If i export that entity from the import export framework i get that 1 employee from the database.

Employee(Master data)

Human resources

DMFEmployeeEntityClass

DMFEmployeeEntity

DMFEmployeeTargetEntity

So my question is, where are all my employees?

Thanks,
Matthew

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

nunomaia 25 Moderator on at

Like (0)

Report

Your Employees should be in table “Employees”. If is setup properly DIXF, records should be exported into table DMFEmployeeEntity.

Did you defined a security settings to restrict companies to be exported ?

"Data import export framework > Common > Processing group"

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Matthew

You have verified the DMFEmployeeTargetEntity query?

This query used by DIXF, start with the HcmEmploymentDetail table joined with the HcmEmployment table.

So, verify the HcmEmploymentDetail table.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Matthew F,

DMFEmployeeEntity is a staging table and contains data that was uploaded to AX from external source like csv via DMF framework or was populated from AX to export data later.

So it will never match data that you have in AX because will contains records connected to ALL import\exports that were done with this entity.

1 record in this case means that some one did import of one record from external source to this table but it does not mean that this empl even exits in AX.

If you want to get data via SQL you need to query actual tables like HcmEmployment, HcmEmploymentEmployee and so on.

Also there are couple of view available like HcmEmploymentView or HcmEmploymentCube that contains denormalized data.

Another option is to use DMF to export all records to a file and work with this file.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Thanks ievgen, this was it. Is there a tech note containing a list of the tables and views?

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Here is a table refrence guide:

www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

If you want to know underlying tables for a form in AX you can go to AOT, find the form, expand it and look at datasource node. It will contain all tables used for this form, sometimes this tables could be temporary so you will have to find code that populates them, sometimes you will have display\edit methods on the form so again you will have to look at code.

Cross-references and debugger are main tools that could help you find everything in AX!

Was this reply helpful? Yes No