Query en Sql para sacar las dimensiones financeras ax 2012

select * from
(
    select
        GENERALJOURNALENTRY.ACCOUNTINGDATE fecha,--fecha
        MAINACCOUNT.MAINACCOUNTID CuentaContable,--cuenta contable
        GeneralJournalAccountEntry.REPORTINGCURRENCYAMOUNT importe,--importe
        DimensionAttributeLevelValue.DISPLAYVALUE dv,
        DimensionAttribute.NAME Nombre,
        GeneralJournalAccountEntry.RECID reciddelatransaccion       
    from GENERALJOURNALENTRY
        inner join GeneralJournalAccountEntry on GENERALJOURNALENTRY.RECID=GeneralJournalAccountEntry.GENERALJOURNALENTRY
        inner join DIMENSIONATTRIBUTEVALUECOMBINATION on GeneralJournalAccountEntry.LEDGERDIMENSION=DIMENSIONATTRIBUTEVALUECOMBINATION.RECID
        inner join MAINACCOUNT on DIMENSIONATTRIBUTEVALUECOMBINATION.MAINACCOUNT=MAINACCOUNT.RECID
        --inner join ABXEBITDADATOSSOBRESALIENTE on MAINACCOUNT.MAINACCOUNTID=ABXEBITDADATOSSOBRESALIENTE.CUENTACONTABLE
        inner join DimensionAttributeValueGroupCombination on DIMENSIONATTRIBUTEVALUECOMBINATION.RECID=DimensionAttributeValueGroupCombination.DIMENSIONATTRIBUTEVALUECOMBINATION
        inner join DimensionAttributeValueGroup on DimensionAttributeValueGroupCombination.DIMENSIONATTRIBUTEVALUEGROUP=DimensionAttributeValueGroup.RECID
        inner join DimensionAttributeLevelValue on DimensionAttributeValueGroup.RECID=DimensionAttributeLevelValue.DIMENSIONATTRIBUTEVALUEGROUP
        inner join DimensionAttributeValue on  DimensionAttributeValue.RECID=DimensionAttributeLevelValue.DIMENSIONATTRIBUTEVALUE
        inner join DimensionAttribute on DimensionAttribute.RECID=DimensionAttributeValue.DIMENSIONATTRIBUTE
    --where ABXEBITDADATOSSOBRESALIENTE.CONCEPTO in (2,3,4,5)       
     )p
pivot (max(dv) for Nombre in ([MainAccount],[División],[Sucursal])) piv   -- **