Xcelerator Template Mapping of Data

[gats1527]

Our business units generate a Trial Balance in their own GL Accounts.  They are then presented with a Cognos Express Xcelerator Excel template with the Account dimensions listed (different then the local unit accounts) and they manually copy and paste from their local file into the template and then they process the template and the data is transferred into the cube.

What we are trying to do is generate a process that will automatically take what the local unit has and based on some mapping rules within Xcelerator it will move the data into the account dimension currently setup within Xcelerator.  Any information or guidance as to how we could accomplish this would be appreciated.

Thanks

Tom