For a data model, you can define which financial dimension combinations must be exported to the target database. You can use these financial dimension combinations for reporting purposes.
On setup of financial dimensions for a data model, a batch job is run to search for and add existing financial dimension combinations to the CDPDIMENSIONS table in D365 F&SCM. The search for financial dimension combinations that fit the data model setup is done in all applicable financial dimension tables in D365 F&SCM. All existing applicable financial dimension combinations are transformed and added to the CDPDIMENSIONS table in D365 F&SCM. When, in D365 F&SCM, new financial dimension combinations are created that fit the data model setup, these combinations are automatically transformed and added to the CDPDIMENSIONS table in D365 F&SCM.
If financial dimensions are set up for the data model, on:
Deployment of the data model, the financial dimensions table is created in the target database. The name of this table is: [schema name].CDPDIMENSIONSSTAGING; where [schema name] is the schema as defined for the data model.
All financial dimension combinations that exist in the CDPDIMENSIONS table in D365 F&SCM are exported to the [schema name].CDPDIMENSIONSSTAGING table in the target database.
Export of the data model, the applicable financial dimension combinations are exported from the CDPDIMENSIONS table in D365 F&SCM to the [schema name].CDPDIMENSIONSSTAGING table in the target database.
Steps
Go to Data modeling studio > Data modeling studio > Data models.
In the list, for the desired data model, in the Dimension field, click the Filter icon.
Note
If already filters are defined for the data model, click the Edit icon.
Click New.
Define the dimension type: 'Ledger' or 'Default'.
In the Type field, select an option.
In the Dimension attribute field, enter or select a value.
Click OK.