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

All responses (12)

Answers (1)

TestBot 938 on at

Like (0)

Report

RE: Get financial dimensions values using code X++

Hi Bharath,

Can u elaborate this.
jerrold-verzosa 65 on at

Like (0)

Report

RE: Get financial dimensions values using code X++

Gonna try this. Thanks!
Verified answer

Community Member on at

Like (1)

Report

RE: Get financial dimensions values using code X++

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.
jerrold-verzosa 65 on at

Like (0)

Report

RE: Get financial dimensions values using code X++

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!
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Get financial dimensions values using code X++

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
jerrold-verzosa 65 on at

Like (0)

Report

RE: Get financial dimensions values using code X++

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
jerrold-verzosa 65 on at

Like (0)

Report

RE: Get financial dimensions values using code X++

How am I going to connect DimensionFinancialTag table with DimensionAttribute? I want to query Purpose and its dimension values. Is it possible?
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Get financial dimensions values using code X++

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
Martin Dráb 233,358 Most Valuable Professional on at

Like (1)

Report

RE: Get financial dimensions values using code X++

"Purpose" is a custom dimension, therefore values must be defined manually. They're stored in DimensionFinancialTag table.
jerrold-verzosa 65 on at

Like (0)

Report

RE: Get financial dimensions values using code X++

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!