more location data required?

It had nothing to do with the model or granularity, it had to do with the fact it worked in Preview but when they did the release they got specific. So unless you specifically labeled the Dimension attribute, or table attribute, Zipcode instead of say "Zip City" it wouldn't work.  That is a big miss.   Maybe my business unit doesn't want it called Zipcode or Postal Code.  Maybe they want it Zip City.    So to me, that's a fail because a true Dimension model (ala Kimball) is based on Business Process and what the business calls it, not what the application wants it to be.