Add dimensions to Excel templates
This article provides information about dimensions, dimensions that have entities, and the dimension controls that are available.
The only value that is present on Microsoft Excel templates after installation is the MainAccount. This is the only dimension that all customers will have. To add the dimensions to Microsoft Excel templates you need to complete the following steps:
- Add dimensions to the DimensionCombinationEntity or the DimensionSet entity.
- Add the dimensions to each template where you want dimensions in separate columns. For more information, see Create Open in Excel experiences.
- Add the capability to look up financial dimension values in Excel.
- Publish the template.
This article shows how to modify DimensionCombinationEntity to enable the dimensions in columns for Excel. The same steps can be used to modify the DimensionSet entity.
Note
This information is subject to change for each release. Therefore, be sure to check back frequently for the most up-to-date information.
Add dimensions to Dynamics 365 Finance
Modifying the DimensionCombinationEntity has been greatly simplified with the release of the Add financial dimensions for OData Addin in Visual Studio.
In Microsoft Visual Studio, click Dynamics 365 > Addins > Add financial dimensions for Odata.
Type the name of the Financial dimension in the Dimension name column. This should be the exact name of the financial dimension. Select the Model that has your extensions. It should be above the AppSuite layer. Click Apply.
.
Compile the project, and then synchronize it with the database.
Note
You must keep the extension name "DimensionIntegration" for the project to work properly.
Your customization is now completed. You can test it in SQL using the following statement.
select * from DIMENSIONCOMBINATIONENTITY
Additional resources
Migrate default dimensions controls to Dimension Entry controls
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기