Thanks Ted, Another question which is related to this... When developing an exploration or report, a lot of time is spent writing custom measures and defining the aggregations. This can take a lot of time and effort. Is there a way to re-use some sort of 'data dictionary' so that you don't have to spend time making the data work each time? I have noticed that when exporting an Exploration as a Report, the data structure is preserved (which is a start) but it would be a lot easier to have defined rules? James. ... View more

I have also had this problem. This is a very important feature request. ... View more

Thanks for that I-Kong, I have had some success with it now - which has been handy. I have discovered some bad performance issues if you try to create calculated items on 165million rows of data, so I had to do some of the initial logic in Query Builder to filter out the data and perform the basic logic. Thanks for passing this do the documentation team, the Query builder is definately not well covered compared to Explorer and Reporter. James. ... View more

Hi Michelle, Yes, a CASE statement would work well. However, I cannot find any example of how to use the statement in any of the documentation for VA, and the link that you send through does not help (aside from "Enter arithmetic operators and expressions such as CASE statements directly in the SQL expression area"). But please explain why the functionality within the Query tool in terms of expression building screens is so deficient??? VA is promoted as a tool that requires no knowledge of SQL, and while the expression builders within VA Explorer/Reporter are great - the functionality of the Query tool is woefully deficient. The documentation I could find on the CASE syntax was here: http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473682.htm I could not find anything related to CASE and VA specifcally. James. ... View more

Hi Falko, Thanks for your reply. The structure of the regions from OpenStreetMap looks to be correct, so can I request that GfK GeoMarketing update their definitions and that the data is refreshed. It is not sensible for VA to render overlay regions using data from a provider that can't be downloaded and checked or simulated. The issue here is that these three regions are ridiculously small (both in area and population) so it is not sensible for the area to be divided into three. Thanks, Jim. ... View more