Skip to main content

Posts

Showing posts with the label Use of query builddatasource in job ranges

use of OLAP Datasource in axapta

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;