Home > X++ stuffs > Finding Dimension Array name in Dynamics AX using X++

Finding Dimension Array name in Dynamics AX using X++

 

Dimension in AX/SQL are stored as arrays as shown below in SysTableBrowser window.

In SysTableBrowser all the fields apart from SalesId are pointing to “Dimension”. This might be quite confusing at times to people who look AX for the first time. In fact the field names are different when stored in SQLDictionary table.

But to determine what exactly each of these financial dimension[_array] points too is illustrated using a sample job

static void FindDimensionArrayName()

{

    SysDictField    sysDictField;

    int                 _array;

    ;

 

    sysDictField = new sysDictField(tablenum(SalesTable), fieldnum(SalesTable, Dimension));

 

    for (_array = 1; _array <= sysDictField.arraySize(); _array++)

    {

        info(strfmt("Dimension value is %2: %1", sysDictField.label(_array),

                                                                    sysDictField.name(DbBackend::Sql,

                                                                    _array,

                                                                    FieldNameGenerationMode::FieldList,

                                                                    tablestr(SalesTable))));

    }

}

DbBackend::Sql

 
DbBackend::Native
 
click to zoom
 

Advertisements
Categories: X++ stuffs
  1. Unknown
    May 6, 2010 at 2:27 pm

    Hi Tommy,that is the enhancement I made to the table browser form, you can read about it here http://daxline.blogspot.com/2010/05/enhanced-systablebrowser-view-only.html

  2. Tommy
    May 5, 2010 at 12:16 pm

    A little off topic, but what are those two buttons on your right hand side in the table browser? What do they do?

  1. October 11, 2010 at 3:44 pm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: