Handling monthly dimension updates when loading data

[raghunori]

Hello Team...We are dealing with our Company's Headcount & Hiring data for our cube design and build. We have dimensions structure in place and cube built around employees, departments, geography, job category, department, management, Headcount/Adds/losses etc..I have a question around what needs to be done when the new months data load file has new headcount data. Because the TI process fails often as it doesnt find new Headcount related IDs in for eg: emp dimension file. Basically, the idea is to compare dimension data in the cube every month end with data file (for eg on Emp serial numbers) and then insert the new Empl numbers information in dimension hierarchy and then do a data load into the cube. I am hoping I have put things clearly..Is this all comparison and load possible in a TI process as we are doing manually adding some of these dimension attributes from the error log file before the load becomes a success..