General Ledger Default Dimension by Name

General Ledger Default Dimension by Name

Submitted by Nathan Clouse on 09/27/15.

A simple view that provides the name for a Default Dimension. Not particularly useful on its own but teamed up with other views can be very handy.

AX Version: 

Module: 

CREATE VIEW [dbo].[vw_LedgerDefaultDimensionByName] 
AS 
  SELECT displayvalue, 
         dft.description, 
         dalvv.defaultdimension, 
         dalvv.dimensionattributeid, 
         da.NAME, 
         dalvv.partition 
  FROM   defaultdimensionview dalvv 
         JOIN dimensionattribute da 
           ON da.partition = dalvv.partition 
              AND da.recid = dalvv.dimensionattributeid 
         JOIN dimensionfinancialtag dft 
           ON dft.partition = dalvv.partition 
              AND dft.recid = dalvv.entityinstance 

go