Some basic methods for Dimensions in LedgerDimensionFacade class in D365 / AX7

In Dynamics 365 FO , Microsoft has introduced few more classes to help us with the Dimension related requirements. Here are few name of classes and method that can be used.

1. LedgerDimensionFacade:

This class has multiple methods that cater to different requirements. We discuss a few in the following:

For instance the most common operation that is required is to merge a Ledger dimension and a Default dimension:

We have two recIds of default and ledger and dimensions, and we want to merge the two dimensions value into one ledger dimension

We have a combined ledger dimension now.

Also there is another class that holds a few more methods for DefaultDimension operations:

2. LedgerDimensionDefaultFacade: 

This class will help us to perform action over default dimension. Like Merge specific default dimensions into single default dimension, replace attribute value etc.

Using entities to export data to custom database (BYOD) in AX7 / D365

This topic explains how administrators can export data entities from Microsoft Dynamics 365 for Finance and Operations into their own Microsoft Azure SQL database. This feature is also known as bring your own database (BYOD). 

We start by starting with the following steps:

Create your custom database in SQL

Create Login for the DB created

Assign DB to the created login

Now go to Data Management in AX.

Next go to Configure Entity export to database

Now click on Validate. You will receive following error initially

To resolve this follow the following steps:

Now validate again

Now click Publish.

Select The entity that you want to use for data export

Now create an export project for the entity you have published

Export data through this entity and the data will be dumped into your custom database