TM1 Forum

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

I suppose it depends on what you mean by "they process the template". The most robust method to do what you want is going to be to write a turbointegrator process to take the local file and then, in conjunction with a mapping cube, send the local account number-based balances to the corporate accounts. This will be rather involved and if you have never done this before it will turn out to be quite a task. I suggest you sign up for some training.

When you say Process if you mean they use the "Process" functionality from the Excel add-in then the easiest answer would be to add a translation table to your Excel template and use a VLOOKUP formula to replace the local account with the corporate account (which would then be referenced in the DBS formula).