Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Using BYOD and exporting the Financial dimension values ( [dbo].[FinancialDimensionValueEntityStaging] ) I get all the dimension values and the descriptions. I would like to pair them to items (Released Product Details). How do I achieve this?
I know there is a "DEFAULTLEDGERDIMENSIONDISPLAYVALUE" column in Released Products V2 entity ( [dbo].[EcoResReleasedProductV2Staging] ) but it shows it with a bunch of lines inserted "-----2041-"Any better way to achieve this?
What is it that you want to do exactly?
To you want to associate each item with a findim in D365FO?
Can you explain your question by providing some more details? Like Ludwig, I'm not able to understand your issue or what you want to achieve.
I'd like to export the default financial dimensions for all products. Namely those found in "Released Product details" in D365FO.
The entity "Released products V2" export gives me a column called "DEFAULTLEDGERDIMENSIONDISPLAYVALUE". Financial dimensions entity gives me all the dimension values.
Obviously I can not join on the displayvalue.
In AX09 you could right click on any field and easily get more information in regards to the database. It's much more difficult in D365. If I could get the entities used from a form name for instance that would really help out.
To configure this go to the following menu General Ledger --> Chart of Accounts --> Dimensions --> Financial dimension configuration for integrating applications. In here you can configure 4 options:
* Default dimensions format, dimension layout used for default dimensions (like you set up on customers / vendors / items / etc)
* Ledger dimension format, dimension lay out used for general ledger postings
* Budget register dimension format, dimension lay out used for budget register entries
* Budget planning dimension format, dimension lay out used for budget planning
As you can have different set up of dimension formats in your account structure, you need to tell D365 how to handle this while exporting / importing. Since you can only define one setup per options, in general you would create one big string in an order of your choosing containing all the relevant dimensions for your company, however you are completely free in doing this. This will give you the flexibility of hiding dimensions in exports as well (like the personnell number for example).
Please see the screenshots below for extra reference.
Yes, this helps of course. Any way to specify a particular format to be used for an export project to Azure SQL? The issue of course, is that I would still have to unnest/split the displayvalue string into seperate rows to be able to join other tables.
As far as I know it is only 1 general template you can setup for dimensions. So creating a specific one for Azure SQL is not possible.
Thanks for the quick reply. I will take the default fields and use string splitting function.
Business Applications communities