Technical Web Log

I just came across a scenario where I had to import the Projects as WIPs from legacy system. For that I imported Projects and Project Contracts in the System, partly using DIXF and partly using excel add-in. During the import, I figured out that Funding Rules Allocation were not updated, so I had to write a custom job to updated that. Later, I saw that Financial Dimensions on Projects were imported correctly but those on Funding Source were empty, so I wrote following job to see which dimensions are currently attached to the Project Contract. I am sharing it with you all so somebody might not need to reinvent the wheel. Happy DAXing! ☺ static void getProjContractDims(Args _args) {     InventTable         inventTable;     SysExcelApplication application;     SysExcelWorkbooks   workbooks;     SysExcelWorkbook    workbook;     SysExcelWorkshe...