Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
How can DimensionAttributeValueCombination be found for main account, business unit, and department dimensions as string values?
Maybe you want to get DimensionAttributeValueSet? In this case you can use DimensionAttributeValueSetStorage class.
Would like to be able to find the DimensionAttributeValueCombination record without knowing the Id, using the string values for dimensions. Thanks
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.
Check the following link
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.
Just to be sure, have you referred to the whitepaper on Dimensions?
this is the method:
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,
Business Applications communities