Share
Reportwhen i upload DMF it says financial dimension XXX doesn't exist although it's exist in the system and exist in setup of the application for the excel format
any help please
You’re offline. This is a read only version of the page.
77
when i upload DMF it says financial dimension XXX doesn't exist although it's exist in the system and exist in setup of the application for the excel format
any help please
Can you share a screenshot of the dimensions setup on the source data format and a screenshot of the account structure? It is correct that the DMFDimensionHelper is using the dimensions different. You can have multiple account structures with different dimension setup. Also a source file can contain multiple main accounts and different account structures. For that reason, you need to setup the dimensions on the source data format for the whole import.
E.g. you have two account structures:
A: Main account - Business Unit - Department
B: Main account - Cost center - Business unit
To be able to load a file supporting these different setups and take care of all three dimensions, you need to setup the source data format like this:
Main account - Business Unit - Cost center - Department.
In case of a main account for A, you can then use the next string: "120012-BU01--export". Here the value for the Cost center is empty.
Hi Andre
all setup is okay dimension in Application Tab with separator
i checked the account structure from the ledger everything is okay but as i said
i opened the debugger i found that the code go throw this class
DMFDimensionHelper::generateDynamicDimension( "MyLedgerDimension with "-" separator ") like "120012-BU01-export"
then validate the value from this table
DimensionAttributeValue::findByDimensionAttributeAndValueNoError(_dimensionAttribute, _dimensionValue, false, true);
and here he gives that error as i said although the dimension value exist in financial dimension
and i found that the DMFDimensionHelper::generateDynamicDimension method reads financial dimension for the main account different from the finanical dimension which is in the account structure
for example main account X should follow costcenter in accountStructre
the DMFDimensionHelper::generateDynamicDimension see the main account should have value from the financial dimension BusinessUnit
i tried to add the value of the costcenter in businessunit it doesn't give the error but it publish without dimesnion value only main account
i tried to create new account structure .. and also tried to remove the exist structure and add again to the ledger but same issue exist
any help ?
Hi AXFourms,
Ashwin mentioned the 'Source data format'. On the second tab, you can indeed specify which dimensions in what order will be provided in a source file or should be exported in that format. Check if this matches your string with dimension values and if the separator is correct.
In your source data format can you share screenshot of "application" tab so we can see what is defined for the dimensions. Also can you share your Accounting structure to see the dimensions used.
What are you importing via DMF what entity ?
i opened the debugger i found that the code go throw this class
DMFDimensionHelper::generateDynamicDimension( "MyLedgerDimension with "-" separator ") like "120012-BU01-export"
then validate the value from this table
DimensionAttributeValue::findByDimensionAttributeAndValueNoError(_dimensionAttribute, _dimensionValue, false, true);
and here he gives that error as i said although the dimension value exist in financial dimension
Hi,
please verify your financial dimension values. It probably contains a not valid value. check your dimensions sequence also, it should match with the excel format setup.
Best
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (