In what table can I find the cost center associated to a Project?

(0) Share

Report

Posted on by VickyD

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?

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (1)

Report

Hi,

Please check the link below.

learn.microsoft.com/.../ledgeraccountcombinations

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi VickyD, In addition to above suggestions, you can check this article

rahulmsdax.blogspot.com/.../get-default-financial-dimension-values.html

Was this reply helpful? Yes No
VickyD on at

Like (0)

Report

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?

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

You can refer to the view and use that table as mentioned in the view datasource.

Thanks,

Girish S.

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
VickyD on at

Like (0)

Report

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?

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

As I already mentioned in my previous reply about the tables. You can join those tables to get the required output.

Thanks,

Girish S.

Was this reply helpful? Yes No
VickyD on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

You need to have visual studio access to find out the table used in the view. With table browser extension you can't see the tables used in the view.

Thanks,

Girish S.

Was this reply helpful? Yes No