TM1 Forum

I have found that all my dimensions that are updated from an ODBC source are duplicated. For example I have a products dimension that is updated from an ODBC source. The ODBC source contains both elements and consolidations so when I have updated the products dimension I have for example:

Σ ALL PRODUCTS
n IPAD 32 GB 3G
n IPAD 64 GB 3G
n IPAD 32 GB Wifi
n IPAD 32 GB Wifi

This is how I want the dimension to lock like, i,e the consolidation ALL PRODUCTS and then under the consolidation all the elements that belons to that consolidation, but when I update the dimension I also get all the individual elements once again as single elements (ie "duplicated") so in fact the dimension looks like this:

n IPAD 32 GB 3G
n IPAD 64 GB 3G
n IPAD 32 GB Wifi
n IPAD 32 GB Wifi
Σ ALL PRODUCTS
n IPAD 32 GB 3G
n IPAD 64 GB 3G
n IPAD 32 GB Wifi
n IPAD 32 GB Wifi

Is this the normal behaviour of TM1 or is there any setting in the Turbointegrator process I should change in order to not get all the elements twice?

You probably have the dimension sort order set to manual. Set the order to hierarchy by right clicking on the dimension in the explorer window and selecting the order option.

It's not really stored that way. You can get what you want by using Edit Dimension Structure. Once the Dimension Editor opened, choose Hierarchy Sort, then Set Dimension Order and Save.

If you don't want to do the above, check your TI process. How do you insert the element?
I suspect that you only use DimensionElementComponentAdd function. If you do, then before you call that function, call DimensionElementInsert first.
I noticed this thanks to lotsaram (you check his post here)

Thanks a lot this really solved a problem that has been bugging me for long.