Wednesday, February 22, 2023

Export Financial Dimensions using x++

 Export Financial Dimensions using x++. 

Tables list is mentioned below.


public class ExportFinancialDimensionService extends SysOperationServiceBase
{

    public void processOperation()
    {
        DimAttributeMainAccount     dimAttributeMainAccount;
        DimAttributeOMCostCenter    dimAttributeOMCostCenter;
        DimAttributeProjTable       dimAttributeProjTable;
        DimAttributeAssetTable      dimAttributeAssetTable;
        DimAttributeOMDepartment    dimAttributeDepartment;
        DimAttributeOMBusinessUnit  dimAttributeBusinessUnit;
        DimAttributeVendTable       dimAttributeVendTable;
        DimAttributeCustTable       dimAttributeCustTable;

	// BusinessUnit
	while select dimAttributeBusinessUnit
	{
	    info(Strfmt('%1 - %2',dimAttributeBusinessUnit.Value, dimAttributeBusinessUnit.Name);
	}

	DimensionFinancialTag  			siteDimensionFinancialTag;
	DimensionAttributeDirCategory   dimensionAttributeDirCategory;

	// Site
	while select siteDimensionFinancialTag
	    join dimensionAttributeDirCategory
	        where siteDimensionFinancialTag.FINANCIALTAGCATEGORY == dimensionAttributeDirCategory.DirCategory
                && dimensionAttributeDirCategory.DimensionAttribute == DimensionAttribute::findByName(#Site).RecId
	{
	    info(Strfmt('%1 - %2',siteDimensionFinancialTag.Value, siteDimensionFinancialTag.Description));
	}
		
	// Department
	while select dimAttributeDepartment
	{
	    info(Strfmt('%1 - %2',dimAttributeDepartment.Value, dimAttributeDepartment.Name);
	}
		
	// MainAccount
	while select dimAttributeMainAccount 
	{
	    info(Strfmt('%1 - %2',dimAttributeMainAccount.Value, dimAttributeMainAccount.Name);
	}

	//Assets
	while select dimAttributeAssetTable
	{
	    info(Strfmt('%1 - %2',dimAttributeAssetTable.Value, dimAttributeAssetTable.Name);
	}

	// Customers
	while select dimAttributeCustTable
	{
	    info(Strfmt('%1 - %2',dimAttributeCustTable.Value, dimAttributeCustTable.Name));
	}
    }
}


Keep Daxing.



No comments:

Post a Comment