Find DimensionAttributeValueCombination recid using dimension string values

(0) Share

Report

Posted on by Community Member

How can DimensionAttributeValueCombination be found for main account, business unit, and department dimensions as string values?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Mea_ 60,284 on at

Like (0)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

Hi solutionx,

Maybe you want to get DimensionAttributeValueSet? In this case you can use DimensionAttributeValueSetStorage class.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

Hi Ievgen,

Would like to be able to find the DimensionAttributeValueCombination record without knowing the Id, using the string values for dimensions. Thanks

Was this reply helpful? Yes No
Suggested answer

Nasheet Siddiqui 440 on at

Like (0)

Report
RE: Find DimensionAttributeValueCombination recid using dimension string values

You can use

AxdDimensionUtil::getDefaultAccountId(stringValues) to get the ledgerDimension.
LedgerDimension is the RecId of DimensionAttributeValueCombination table.

Below is an example for the budget planning ledger dimension.

community.dynamics.com/.../get-budget-plan-ledger-dimension-from-value

Was this reply helpful? Yes No
startax 1,845 on at

Like (0)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

Check the following link

howtoax.com/how-to-import-item-dimension-group-from-csv-in-microsoft-dynamics-ax-2012-using-x

howtoax.com/financial-dimensions-in-microsoft-dynamics-ax-2012

howtoax.com/creation-of-dimension-groups-in-ms-dynamics-ax-2012

Was this reply helpful? Yes No
André Arnaud de Cal... 299,349 Super User 2025 Season 2 on at

Like (1)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

Hi Dinkar,

Please provide only valuable information in your answers. Importing item dimension groups has nothing to do with the original question. Your contributions will be monitored to see if it will be considered as a spam bot. So please read the question carefully and stop sending replies with links to one certain website.

Was this reply helpful? Yes No
April Olson on at

Like (0)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

Just to be sure, have you referred to the whitepaper on Dimensions?

http://download.microsoft.com/download/4/E/3/4E36B655-568E-4D4A-B161-152B28BAAF30/Implementing_the_Account_and_Financial_Dimensions_Framework_AX2012.pdf

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

this is the method:

kiwiaxguy.blogspot.com/.../setting-ledgerdimension-field-on.html

Was this reply helpful? Yes No
Anton Tjiptadi 2,013 on at

Like (0)

Report

RE: Find DimensionAttributeValueCombination recid using dimension string values

Hi,

Can ask your advice whether it is true that DimensionAttributeValueCombination holds data already posted to G/L while DimensionAttributeValueSet is hols data not yet posted to G/L ?

If that so, once some transaction with default dimension key in is posted, the record from DimensionAttributeValueSet will be moved to DimensionAttributeValueCombination ? These two table will not have the same data, right ?

Again, if so, is there a built-in view that holds these two table, some kind of join table so we do not need to look at two table (if we did not know data is posted / invoiced or not)

Thanks in advance,

Was this reply helpful? Yes No