How can I get default dimension based on Ledger account in AX -2012

See more:

SQL

Hello,

I have tried to get default dimension based on Account number in AX 2012. But I have not found Table "LEDGERCONTROLDIMENSION" and got alternative table "DIMENSIONATTRIBUTEVALUECOMBINATION" for AX 2012 but I have no idea how to use this table.

How can I get Default Financial dimension for particular Account. Please see below query of AX - 2009. If anyone have idea please share it to me.

Select LC.NUM as SiteID,    
D.Description as SiteDescription    
from LEDGERCONTROLDIMENSION LC    
inner join DIMENSIONS D on LC.NUM=D.NUM and LC.DimensionCode=D.Dimensioncode    
where LC.AccountNum=@TrimmedAccount and LC.DimensionCode=0  

Thank you in Advance.