You’re offline. This is a read only version of the page.
In the Project screen, I can see that a Project is associated to a Cost Center under Default Financial Dimensions section.
However, I am not able to find it in the underlying tables. I see a DefaultDimension value in the ProjTable which I assume should lead me to the Cost Center but I am not able to get the cost center i.e., if I look up this value in say DimensionAttributeValue or DimensionAttributeValueCombination tables.
What am I missing?
Yes, I did manage to get that using your previous response.
I was just trying to find out if there was a way I could have figured it out myself based on the view name you had provided earlier so that I can use that method the next time I need to know what tables a view is based on.
I don't have access to the code base. I am basically relying on the table browser extension in Chrome and D365 portal to figure things out. Is there a way to find out what tables a view is referring to using one of these?
You can use DimensionAttributeValueSetItem, DimensionAttributeValue, DimensionAttribute.
Relation betweeen DimensionAttributeValueSetItem and ProjTable will be below.
"DimensionAttributeValueSetItem. DimensionAttributeValueSet == ProjTable.DefaultDimension".
You can filter "CostCenter" in the table DimensionAttribute. Name field.
Thanks,
Girish S.
Thanks. While I can see this view and am able to do the tie up visually, this view does not show up in the Export to Data Lake list of tables. I suppose that's because it's a view and not a table or perhaps it has not been set as exportable.
Is there an underlying table I can leverage instead?
Hi VickyD, In addition to above suggestions, you can check this article
rahulmsdax.blogspot.com/.../get-default-financial-dimension-values.html
Hi vickyD,
You can refer to the view named DefaultDimensionView - There will be a field named "Name" where you can filter by Cost center.
Relation will be ProjTable.DefaultDimension == DefaultDimensionView.DefaultDimension.
Thanks,
Girish S.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (