Dimensions - AX 2012 - DefaultDimension field and related values in tables

Just some t-sql queries (as a reminder) to return the records of a particular dimension (of course you can join them and so on, but I just wanted to list them in order):



select DEFAULTDIMENSION, * from ANY_TABLE -- (or any other table with financial dimensions)

select * from DIMENSIONATTRIBUTEVALUESET  where RECID = yyyy -- (DEFAULTDIMENSION field's value above)

select * from DIMENSIONATTRIBUTEVALUESETITEM where DIMENSIONATTRIBUTEVALUESET = yyy -- (DEFAULTDIMENSION field's value above)

select * from DIMENSIONATTRIBUTEVALUE where RECID = zzz -- (DIMENSIONATTRIBUTEVALUE field's value)

select * from DIMENSIONATTRIBUTE where RECID = xxx -- (DIMENSIONATTRIBUTE field's value)