Finance | Project Operations, Human Resources, ...

Department Hierarchy export option

(0) Share

Report

Posted on by AkankshaJha

100

Hello,

From Organization Administration page, if i click on Department Hierarchy; there is no option appearing to export this data.

Is there a way to pull the hierarchy structure in one single sheet?

Thanks,
Akanksha Jha

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Akanksha,

There is no simple option to export the Department Hierarchy (or position & organizational hierarchy).

Wat you could do is export the data via data entities, and import those in visio or Power BI.

Typically Visio is the easiest solution, but will need some time to get this working:

Was this reply helpful? Yes No
qianwang 7,168 on at

Like (0)

Report
Copy link

Link copied!

Hi AkankshaJha,

Yes. Unable to export department hierarchy from UI.

Therefore it is recommended that you use Microsoft Visio to edit the data entity.

This is an example of exporting the position hierarchy in ax. You can refer to it.docs.microsoft.com/.../export-a-position-hierarchy-to-microsoft-visio

Regards,

QianQW

Was this reply helpful? Yes No
AkankshaJha 100 on at

Like (0)

Report
Copy link

Link copied!

Hi QianQW,

I have already used Microsoft Visio option for Position Hierarchy; but the issue is related to Department Hierarchy where this option is not available.

Regards,

Akanksha Jha

Was this reply helpful? Yes No
qianwang 7,168 on at

Like (0)

Report
Copy link

Link copied!

Hi AkankshaJha,

Yes, But you can still export the departments. Then import the data to Organization Chart template.

Regards,

QianQW

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Just to have all the information. The data entity that holds the department hierarchy (all organizational hierarchies) is the following:

Please reach out for additional questions.

Was this reply helpful? Yes No
AkankshaJha 100 on at

Like (0)

Report
Copy link

Link copied!

Hello,

So it means that the hierarchical (graphical) export of department is not possible; only the export to excel can be done for the complete list of departments.

Hope my understanding is correct.

Regards,

Akanksha Jha

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes,

You can only export the departments and the department hierarchy into excel.

Was this reply helpful? Yes No