QueryName querySource;
OLAPDatasourceRange DSRange;
OLAPDatasourceRelation DSRelation;
OLAPDatasource datasource;
OLAPDatasourceField DSField;
Query query;
QueryBuildDataSource buildDatasource, parentBuildDataSource;
int i,dim, parentIndex;
int dsCount;
boolean newDim;
DictTable dictTable;
QueryBuildDataSource ds;
QueryBuildRange br;
Range _rangeStr;
DictTable dictTable1;
DictField dictField;
;
querySource = 'Bbde';
query = new Query (querySource);
dsCount = query.dataSourceCount();
buildDatasource = query.dataSourceNo(1);
dictTable = new DictTable(buildDatasource.table());
print dictTable.name();
pause;
br = buildDatasource.range(1);
dictTable1 = new DictTable(br.table());
dictField = new DictField(br.table(),br.field());
// br.value(strfmt('%1',mkdate(6,6,2008)));
_rangeStr = br.toString();
print br;
print br.field();
print _rangeStr;
pause;
Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...