List of main accounts with default financial dimension values

(0) Share

Report

Posted on by CapsLock

1,419

Hi,

I would like to review all dimensions that have set as default on main accounts. Is is possible to extract that in excel? With data management maybe? I can't find a data entity that gives me that though.

I would like a list of all main accounts with the default dimension values set against them. These fields:

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Use "Main Account legal entity override" data entity and this is found in "Defaultdimensionvalue" column

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi CapsLock,

I manage it with the Open In Excel feature, or you can use the data management workspace and export "Main Account legal entity override", like Ramit Paul stated.

In the Open in Excel feature you will need to add the Default dimension columns with the Designer. I build my template and saved it locally, now I only mange these rules from the Excel sheet.

Was this reply helpful? Yes No