TM1 Forum

Hello,
Our accounting functions have been outsourced and as such the account codes and the consolidations that will be used will be different from our current ones. I am planning to rebuild the GL Account dimension using xdi in our dev server and copy it over to the production server.My question is, what files do I need to bring across to the production server so that I get to see the new dimension and all the subsets?I just want to make sure I get everything.Thank you.

If you are using an .xdi file - just run the xdi dimension save over your production environment.

For what its worth - a change in your chart of accounts is normally a complicated change in TM1. If you have a 1-to-1 mapping of old accounts to new accounts then possilby easier to user Alias's, ensures any rules or TI's that run reference specifc accounts/hierarchies etc... will continue to work.

Do I need to do a DimensionDeleteAllElements in a TI process first before saving the xdi file? Or is saving the xdi file enough to get rid of the old elements?

Telula

Saving the XDI will rebuild your dimension fully. There is no need for a TI with DimensionDeleteAllElements.

We've just been through an account mapping exercise. Sadly it was no where near as simple as a 1:1 mapping to different names. We pulled 4 CoA in to 1 CoA, and there was a lot of mapping to do. However, you can do this relatively easily in TM1 using Strings in Cubes.

Regards


Paul

I have 2 different hierarchys that are used for different purposes. one is your classic chart of accounts for financial reporting, the other is a hierarcy where the leaf elements of the chart of accounts are grouped under a single consolidation called expenses. In my xdi, theses hierarchies sit on top of one another.When I try to save it, it says there are duplicate elements because they appear in the different hierarchies. How do I solve this. I would like to use xdi.

its ok, no need to reply to the previous post, i figured it out.