Microsoft Dynamics AX (Archived)

Update financial dimension in Employee profile

(0) Share

Report

Posted on by Community Member

i want to add dimension employee for all employees to use sql so

I want to know table name for this dimension ..

Does anyone know the name of table!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello hawraa,

Please have a look at the following posts that can give you some hints where to get started

community.dynamics.com/.../115208

msdn.microsoft.com/.../hcmworker.getdefaultdimension.aspx

sumitsaxfactor.wordpress.com/.../replace-a-financial-dimension-in-default-dimensions-ax-2012

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Consider :

whether this is to be linked to employee table if so then - what happens when an employee leaves- you will nor be able to remove from HR employee table when there are related financial postings

who will be able to see financial postings on which inquiry screen. report for which employees? e.g CEO salary detail

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thank you for replay

i updated but when i used this dimension on journal showing me this error

note : i change the employee id from (ddd-170) to (ddd-00170) form all table employee also (DimensionAttributeValueCombination) table but still showing me same error

Was this reply helpful? Yes No
David Thaivo 45 on at

Like (0)

Report

Hi hawraa,

Here you are : HcmEmployment, colum: DefautDimention.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The problem has been resolved.

thank you

Was this reply helpful? Yes No