Geo hierarchy from Country Codes, unresovled codes

[james_batchelor2]

Gurus,

The 1.17 update...nice step forward.

I am however still trying to get the few unresolved country codes found in our data, resolved.

ie.  for whatever some data for Spain is tag SP, the ISO code is ES..  So I tried to replace SP with ES in PREPARE tab..but the hierarchy still sees SP.

I cannot manually type in the country name or assign it to any country I want in the reconcile menu.

So I am stuck with a few codes I cannot assign anywhere, even though I know the country..

I would have thought  a replace data x with y would have done it...or let me bypass the automatic logic and manually place unresolved data in the right place.

other than editing the source Excel file, I see no option.

other ideas?

thanks

jim

[TammyPowlas]

It's probably not refreshing the hierarchy after you did the replace (my guess)

Could you create a second hierarchy to see if it fixes it?

I keep meaning to try the Esri Maps (as a trial solution) to see if that fixes the unresolved mapping issues but haven't yet - see

[james_batchelor2]

Yes that's it.  I finally got back around to playing with this data set.  If I make the change to the Country Code and make a new hierarchy, it scans everything again and takes the replaced data.  So if a new code comes on data refresh...the hierarchy will not use it until I make another hiearchy?  not good..

jim

[TammyPowlas]

Something for you to add / suggest to Idea Place - if you post a link here, I will vote for it

[james_batchelor2]

I don't consider that an idea...  that is functionality not working as expected. 

I would expect determined fields to update with changes in the data.  This is true for time hierarchy.  As new dates come in, is not the time hiearchy adjusted accordingly?  Or do I have to rebuild it every time new dates come in?

[Henry_Banks]

Hi,

I see your point.  If data > edit, then refresh, followed by 'edit reconciliation' (on the hierarchy) doesn't show the new values, I can understand your frustration.

Are you in a position to log a ticket with Support to request a bug fix, or at least ascertain the viability of the suggestion?

Regards,

H