web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How does DimensionValues[1]…[n] work on LedgerTrialBalanceTmp.DimensionValues

(0) ShareShare
ReportReport
Posted on by 87
In the LedgerTrialBalanceTmp table I found the field DimensionValues (EDT = DimensionSetSegmentValue, String Size = 30). Yet in forms and code I see it used like this: DimensionValues[1], DimensionValues[2], etc. I also looked in SQL and found multiple dimension columns in related table.

I’m trying to understand:

1. How this single DimensionValues field can behave like an array of slots (indexed [i]).
2. How the system stores multiple distinct dimension values inside one string field
3. How it then allows access via DimensionValues[1], DimensionValues[2], etc in code.

Regards,

 
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 696 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 607 Super User 2025 Season 2

#3
CU05031448-0 Profile Picture

CU05031448-0 576

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans