Get financial dimensions values using code X++

(0) Share

Report

Posted on by jerrold-verzosa

How to get all Financial Dimension Values using X++.

I want to fetch Dimension Value and Description in the 2nd picture.

I already checked the form(DimensonValueDetails) but the controls(GroupValue and GroupDescription) have Values(Common-table) Data source. Do you have any idea how to fetch this data?

General Ledger > Chart Of Accounts > Dimensions > Financial Dimensions

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Martin Dráb 239,880 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

It depends.

First of all, it depends on whether you want to values already used as financial dimensions or all values that could be potentially used as dimensions (such as all cost centers).

For example, if you have ten cost centers but only one was used as a dimension, you'll find one record in DimensionAttributeValue table. If you want to see all potential values, you have to look into the table with cost centers (you can use DimAttributeOMCostCenter view for this purpose).

Was this reply helpful? Yes No
Community Member on at

Like
a
(1)

Report
Copy link

Link copied!

You can take help from this view FinancialDimensionValueEntityFinancialTagView.

Was this reply helpful? Yes No
jerrold-verzosa 65 on at

Like
a
(0)

Report
Copy link

Link copied!

I looked at DimAttributeOMCostCenter and it has the Name field.

How about this Purpose?

Where should I get the Name and Description field?
[quote]
It depends.

First of all, it depends on whether you want to values already used as financial dimensions or all values that could be potentially used as dimensions (such as all cost centers).

For example, if you have ten cost centers but only one was used as a dimension, you'll find one record in DimensionAttributeValue table. If you want to see all potential values, you have to look into the table with cost centers (you can use DimAttributeOMCostCenter view for this purpose).
[/quote]

Thanks!

Was this reply helpful? Yes No
Martin Dráb 239,880 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

"Purpose" is a custom dimension, therefore values must be defined manually. They're stored in DimensionFinancialTag table.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Jerrold-verzosa,

What do you try to achieve here at the end of the day?

That is, why you need those data and for what purpose?

Best regards,

Ludwig

Was this reply helpful? Yes No
jerrold-verzosa 65 on at

Like
a
(0)

Report
Copy link

Link copied!

How am I going to connect DimensionFinancialTag table with DimensionAttribute? I want to query Purpose and its dimension values. Is it possible?

Was this reply helpful? Yes No
jerrold-verzosa 65 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to know how to fetch the values in Financial dimension because I'm going to use it as a filter/parameter for my UI Builder. Thanks

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Jerrold-verzosa,

Is my understanding correct that you want to restrict the data users can see in the UI based on financial dimensions?

Is that what you try to achieve?

Best regards,

Ludwig

Was this reply helpful? Yes No
jerrold-verzosa 65 on at

Like
a
(0)

Report
Copy link

Link copied!

As of now, I just want to know where to fetch the records based on my screenshots previously.

I want to achieve this in my UI Builder.
Thanks!

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like
a
(1)

Report
Copy link

Link copied!

You can try this,

View FinancialDimensionValueEntityFinancialTagView contains custom dimension values .

View FinancialDimensionValueEntityExistingListView contains dimension values from fixed List

View FinancialDimensionValueEntityView contains union of all, You can add filter to field Dimension attribute. and get values.

Was this reply helpful? Yes No