Microsoft Dynamics AX (Archived)

Extra field in DimensionAttributeValueCombination table in AX

(0) Share

Report

Posted on by Community Member

Anyone any explain me how the extra flied are showing in DimensionAttributeValueCombination Table browser

But when we expend the table field only few tables are there

please any one answer on these its urgent

thanks in advance

Only few fields are there under the table nodes

But if we open the table browser there are so many fields

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry i not mentioned the version in above message . Which was talking above its related to Ax7

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Can any one explain why extra field come in Table browser of DimensionAttributeValueCombination

Its urgent

Thanks in advance

I am talking on AX7

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

Like (0)

Report
Copy link

Link copied!

What extra field are you talking about?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi martin u can see the above screen shot in that only 15 fields we can see

but once i open the table browser then i getting extra filed also

u can see the above screen shot

how that account,reference ,account value, agreement etc etc

pls if can see in ur ax7 environment means check once

when in DimensionAttributeSet table also same problem

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

There some fields like DEL_CombinationHash1,DEL_CombinationHash2,DEL_CombinationHash3,DEL_CombinationHash4 and DEL_CombinationHash5

why they used these Fields ?

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

Like (0)

Report
Copy link

Link copied!

It seems to me that those extra fields are actually expanded dimensions of the dimension combination. And I think it's done by DimensionCombinationPreviewPart, referenced by the table in Preview Part Ref property.

Regarding those DEL_ fields, this a common pattern for marking fields as "to be deleted", but still allowing people to move their data to other fields. When you're done with data upgrade, you disable their configuration key (SysDeletedObjects60 in this case). They'll be removed completely in a later version.

Because you'll likely aren't doing any data upgrade, you shouldn't ever use these fields and all configuration keys for deleted objects should be disabled.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for Reply martin :)

How the Preview Part Ref property will changes in tables browser i.e means how it will show more fields in table browser ?

Please can you explain me because i want to create a views for that table by selecting some fields based on the fields coming table browser

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

Like (0)

Report
Copy link

Link copied!

My assumption is that if there is a Preview part ref, table browser uses this form part. If you want to see code of the form part, just look into AOT. Nevertheless I don't know how exactly is the new table browser implemented, therefore we'll either investigate it by ourselves (you're welcome to do that, if you're interested), or we'll wait for Microsoft to give us some documentation.

If you want to create a view with these fields, first look if there isn't already anything similar. If not, you can look at code of the DimensionCombinationPreviewPart (and LedgerDimensionPreviewTmp::buildLedgerDimensionPreviewTmp()).

If you don't understand the data model of financial dimensions, you can learn more about it on Dynamics AX GFM Team Blog.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 238,240 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I found a few minutes to look at it and realized that my guess was in a completely wrong direction. If you look into database, you'll find all those fields there, DictTable class is also aware of them (it actually says that the table has 131 fields).

I didn't see any table extension adding them, but it doesn't mean that it doesn't exist. I've found these fields in DimensionAttributeValueCombination.DIMENSION in MetadataExtensionTable (looking directly into SQL Server).

That's all what I know in this moment. I only assume that it's some kernel-level feature to improve performance of queries to financial dimensions by denormalizing the schema.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks martin for quick reply and keep the good work in help the ax developer's like these.

Then how can you see the database in AX7 ? because your telling that "If you look into database".

Was this reply helpful? Yes No