Element of a dimension repeating outside consolidati ...

恭喜发财1

Hi,

I have a geography dimension created and the levels are Country->City->Area.
This dimension gets populated from a csv file using TI process.
The levels Country and City are the consolidations.
Now I want to add one more level 'State' one level above the City.
This change has been done to the source csv file and also to TI process. Level 'State' is also a consolidation for which City is a child and Country is a Parent.
Now whenever I run TI process to update dimension, the State level is getting created with city nested below it. But the city also appear outside of State level i.e. nested directly below Country.
How can I avoid this? I am using 'Recreate Dimension' option in TI process.
Thanks in advance.

sysease

What you've got is an unbalanced hierarchy, meaning you have some Cities that don't have a State parent and are rolling directly to Country. I'm going to assume this is unintentional so it''s probably an error in the file you are using to build the tree. Check your data carefully and make sure it is correct, that every Area rolls to a City, every City rolls to a State and every State rolls to a Country. Check for misspellings too as there is a good chance this is the problem.

wcb79

Hi tomok,

I don't think this is unbalance hiearchy. Every city rolls up in State. The problem is the city is getting repeated. I will try to explain with image.

Old Hiearchy in dimension:
Country C1
    |_City 1
    |_City 2

New hiearchy (where there is a problem)
Country C1
    |_City 1
    |_City 2
    |_State S1
           |_City 1
           |_City 2

I think, it is more clear now.

a23742212

If that's the case then either your data file is incorrect, in the wrong format for the code you have in your TI process, or there is a mistake in the TI. I would have no idea which of those it is because I have literally no information about any. You obviously have not read the .