Notifications
Announcements
No record found.
Hello friends,
I'm trying to share additional financial dimensions to be handled in PowerBI, but unfortunately I'm stuck and don't know what to do next. I have searched for answers but have not found anything.
First, I added the dimensions to Excel and that works very well.
http://axaptadevmallik.blogspot.com/2021/03/add-financial-dimensions-as-separate.html
But now I need to make them available to PowerBI and I don't know/can't find what table these additional dimensions are stored in, so I can reference to them..
https://community.dynamics.com/365/financeandoperations/b/d365financeoperationscloudfronts/posts/create-new-aggregate-measurement-entity-store-in-d365-finance-and-operation-to-be-consumed-in-power-bi-report-in-d365-finance-and-operations
Can someone please help me please?
Hello Shoowtek,
Take a look at this post, it may help you community.dynamics.com/.../retrieve-financial-dimension-string
Dear Mariano Gracia,
Thank you for your reply.
I added additional data source to EcoResReleasedProductV2Entity => DataSource => InventTable => DataSource => DImensionSetEntity.
I also added the relation InventTable.DefaultDimensions == DimensionSetEntity.RecId.
Despite this, after creating a new AggregateMeasurement, I have no available fields from DimensionSetEntity when I try to add a new measure.
Am I doing something wrong?
Hello,
Can anyone suggest how to add financial dimensions (already available in DimensionSetEntity and DimensionCombinationEntity) to SalesCube?
Is no one able to help me?
You don't need to add the datasource as it is already in the entity, you'll see a datasource named DefaultFinancialDimensionsDAVS, this one is in fact the DimensionSetEntity, you'll have to create a new extension for that entity, then you should be able to locate your dimension fields in the datasource, add those fields to the entity extension as new fields
Hello Mariano,
hm, ok. I took the EcoResReleasedProductV2Entity extension and added all the required fields from DefaultFinancialDimensionsDAVS to its fields - they are already theoretically available in this entity.
How do I now make them work in SalesCube in PowerBI?
Should I duplicate the SalesCube and create a new MeasureGroup and then create each new dimension from DefaultFinancialDimensionsDAVS?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
