News and Announcements icon

Dynamics 365 CommunityForums Finance forum How to add lookup Fina...

Finance forum

Under review by Community Managers

How to add lookup Financial Dimension for Excel Template

Posted on by CU28051221-0

Hi guys,

I want to ask how to add lookup in a Data Entity that we create our self, which inside of the data entity has Financial Dimension. I tried to follow some blog also Microsoft, but seems it is not working.

So here it is:

1. I have my data entity, added relation data source to DimensionSetEntity

Property of the relation ->

2. Based on the blog from Microsoft, we should add relation to data entity of DimensionSet

3. Build and sync.

May I know if all these is correct and enough ? since after Refresh data entity, then go to the form that relate to my custom entity, select Open in Excel, there is no lookup ->

I'm following this blog btw,

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/financial/dimensions-overview

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/financial/add-dimensions-excel-templates

Thanks

Categories:

Development / Customization / SDK

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,255 Super User 2025 Season 1

#2

Martin Dráb 232,984 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans