This blog is a quick follow-up to my last post about Geomaps, and the focus of this post is to show another way we can build the metadata to support Geomaps chart types.
While there are restrictions when it comes to country names, there is nothing that stops us from creating additional members that roll up to countries. For example, let us look at the following hierarchy:
As you can see above, I have suburbs rolling up to cities, and finally to countries which is the level the Geomaps will work at. So this means we can store data in non-recognized Geographical members (Manly as an example) but as long as they roll up to recognised members (Australia) then we are good to go.
To test this I have created a data form to enter some data and created a dashboard on top of it. Here is the data in a tabular format:
Yes, it works just fine! pretty cool and extremely powerful if you ask me!