thank you very much. Your solution worked albeit not perfectly as the average coordinates that are calculated look a bit weird on the map. But I suppose this could be refined. Anyway, in the course of working with your data, I actually figured out how to do get Tableau to eat our attribute-based data correctly. It was a matter of having the correct dimensions somewhere on the sheets for the queries to correctly retrieve the data. So your input was very helpful even though I will not use it immediately
That's great news. Thanks for the positive feedback!
One thing to consider: mapping is just a scatterplot of x,y. And also, try to map at the lowest level of analysis. That's why when you put the "correct" dimensions on the sheet it was then rendering what you were expecting.
I still have a lot to learn about cubed db's such as Essbase.