What files to copy in rebuilding dimension

[telula]

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.

[belair22]

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.

[telula]

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?

[paulsimon]

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

[telula]

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.

[telula]

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