Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / My excel download file...
Finance forum
Suggested answer

My excel download file does not contain Financial Dimension

Posted on by 112
Hello everyone,
 
I have a custom table which is one of its field is DefaultDimension. As usual, this is for Financial Dimension.
 
I also created it's data entity for this table, and it looks fine, it can show me the Default dimension value.
When checking through OData url, I can see the field ->
 
Also when checking in Data Management for that Data Entity, the field is there,  by checking the mapping field or target field. 
 
Issue is, in its form it self, when I try to download using Office button -> Export to excel, the excel didn't have this DefaultDimesionDisplayValue.
 
Is there anything that I must do ?
 
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 2,982 on at
    My excel download file does not contain Financial Dimension
    Hi,
     
    First start from this document:
     
     
    Note: It is not necessary to add lookup to each dimension, but for import case you'll enter the value manually.
     
     
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
  • CU28051221-0 Profile Picture
    CU28051221-0 112 on at
    My excel download file does not contain Financial Dimension
    Hi Waed,
     
    I'm sorry, I have trouble of understanding that document. May I get some "pointer" first what actually needed ? 
     
    I'm not expecting that the Excel file I am download can also able to do lookup. But then again, if no lookup I also not sure if there are only columns, I can use it for import.
     
    thanks.
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 2,982 on at
    My excel download file does not contain Financial Dimension
    Hi,
     
    Check the following MS documents:
     
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
  • CU28051221-0 Profile Picture
    CU28051221-0 112 on at
    My excel download file does not contain Financial Dimension
    My data entity already have all the field now from Financial Dimension, because I'm using View DefaultDimensionDAVS
     
    And in Data Management, after Refresh Entity, I saw all these fields already :
     
    But I don't know why after Open in Excel, all these fields still not showing. It looks like it is still follow what's in the UI Grid :
     
    May I know what is wrong ?
     
    Thanks
     
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 2,982 on at
    My excel download file does not contain Financial Dimension
    Hi,
     
    I think it needs customizations, as you know the values of financial dimensions exists on different tables. Did you try to use open in excel?
    Excel add-ins depend on data entities so you can use it.
     
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
  • CU28051221-0 Profile Picture
    CU28051221-0 112 on at
    My excel download file does not contain Financial Dimension
    Hi Waed,
     
    Thanks, I didn't know this. 
    Btw, since this is Financial Dimension, and as in other form, the Financial Dimension it self is put in other section, Is it possible to move the contain of Fin Dim, to the grid ? so I can export to excel also. It is fine to move it one by one, for example: Business Unit, Cost center. And not always all needed.
     
    Is there a trick to do that ? or we strictly have to use "Open in excel" ?
     
    Thanks again.
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 2,982 on at
    My excel download file does not contain Financial Dimension
    Hi,
     
    Export to excel only exports the columns that appears on the grid, but open in excel allow you see the values of the financial dimension based on the data entity that you created and used on OData and data management export.
     
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
  • CU28051221-0 Profile Picture
    CU28051221-0 112 on at
    My excel download file does not contain Financial Dimension
    Hi,
     
    anyone can give some idea on this ?
     
    thanks

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,623 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,463 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans