Hi
How get value of ( Name of Financial dimension sets ) from DefaultDimension value of vendtrans via x ?
I used the code below, but it not work, because he fetch all level of Financial dimension sets,
For some exemple i have only costCentre and OperationUnit for transaction in VendTrans, the result should be only (CCOpUnit) but the query fetch all level of financial dimension sets
Thanks
select DimensionAttribute, DimensionHierarchy, Level_, dimensionHierarchy.NAME, VendTrans.invoice
from dimensionHierarchyLevel
join dimensionHierarchy
on dimensionHierarchyLevel.DimensionHierarchy = dimensionHierarchy.RecId
--and dimensionHierarchy.Name = _dimensionSetName
and dimensionHierarchy.StructureType = 6
and dimensionHierarchy.IsDraft = 0
and dimensionHierarchy.IsSystemGenerated = 0
join DimensionAttribute
on DimensionAttribute.recid = dimensionHierarchyLevel.DimensionAttribute
join DEFAULTDIMENSIONVIEW
on DEFAULTDIMENSIONVIEW.Name = DimensionAttribute.Name
join VENDTRANS
On DEFAULTDIMENSIONVIEW.DEFAULTDIMENSION = VENDTRANS.DEFAULTDIMENSION
and VENDTRANS.INVOICE = '78777'
order by dimensionHierarchyLevel.Level_
