![\"image7\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2015\/08\/image7.png\")
\u00a0Note that the geography names given in cell B2 of the Geography and Filters worksheet must be unique, e.g. each base geography needs a unique name.<\/p>\nThis section describes the process for generating data files for a multiple geography report. We recommend that you manage the indicator data for each base geography in a separate Excel workbook. You will then export the data from each workbook separately and perform a merge. You can have the same or different datasets for each geography. If you have the same datasets then the data selection will be preserved when you change geography, whereas if you do not have the same datasets then there will be a mismatch between which data is selected when you change geography.<\/p>\n
\u00a0Note that the geography names given in cell B2 of the Geography and Filters worksheet must be unique, e.g. each base geography needs a unique name.<\/p>\n
![\"image27\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2015\/08\/image27.jpeg\")
If the areas in your geographies nest, you may wish to include filters that reflect this nesting. In this way, geographies lower in the hierarchy can be filtered according to which area in a higher geography they nest within. For example in a report with Edinburgh post code districts and post code sectors it makes sense to include a Districts filter in the post code sectors workbook. A filter that is available at multiple geographies will stay applied as you switch between these geographies.<\/p>\n
As a first step, you need to export a data file from each workbook separately.<\/p>\n If you are using the atlas-launch.html file to view your report locally<\/a>, there are a few things to be aware of:<\/p>\n <\/p>\n It is imperative that the data files for the geographies are named in a way that matches their order on the \u2018Choose Your Base Geography\u2019 screen of the Publisher. We recommend you name them \u2018data1.js\u2019, \u2018data2.js\u2019, \u2018data3.js\u2019,\u2026 where \u2018data1.js\u2019 is the JSON file for the uppermost geography, \u2018data2.js\u2019 is for the next one down and so on.<\/p>\n The next step is to merge these files into a single data.js file. The Excel Data Manager add-in provides an \u2018IA Merge Files\u2019 button for this.<\/p>\n Click this button. The \u2018Select files to be appended\u2019 dialog allows you to browse to the folder containing your data files. Select the files by clicking and holding down the \u2018Shift\u2019 or \u2018Ctrl\u2019 keys on your keyboard. Then click \u2018Open\u2019.<\/p>\n The files will be appended in the order they are named (alphanumeric) and, as mentioned above, this must match the order of the geographies on the \u2018Choose Your Base Geography\u2019 screen of the Publisher.<\/p>\n The Excel Data Manager will ask you to save the merged data.js file. Browse to the folder containing your report and overwrite the existing data.js file. You will then be asked if you wish to create the local data file.<\/p>\n If you are still in the process of creating and designing your dynamic report and you are using the atlas-lauch.html file to open the report locally, you should select ‘Yes’. As mentioned above this local file will only work if you had the ‘Use Theme Files’ option on the ‘Advanced’ tab of the ‘Output Options’ dialog unticked.<\/p>\n You can now start the report locally (double click the atlas-launch.html file) to view the result.<\/p>\n Once you are happy with your report and you wish to prepare it for upload to a webserver, you should consider running through the above process again. This time you may wish to activate the ‘Use Theme Files’ option on the ‘Advanced’ tab of the ‘Output Options’ dialog. At the step of merging the individual data files together,\u00a0 select the ‘No’ option when asked if you wish to ‘Create Local Data File’. This will ensure that the report uses theme files when opened from a webserver using the atlas.html file. Using theme data files improves the initial loading time of you report as the report only needs to load the data of the first theme when it is first opened. Please see Exporting Data Files<\/a> for further information on theme data files.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" This section describes the process for generating data files for a multiple geography report. We recommend that you manage the indicator data for each base geography in a separate Excel workbook. You will then export the data from each workbook separately and perform a merge. You can have the same or different datasets for each … Continue reading Creating the Data Files<\/span><\/a><\/p>\n","protected":false},"author":22,"featured_media":0,"parent":5311,"menu_order":1,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-5341","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/comments?post=5341"}],"version-history":[{"count":0,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5341\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5311"}],"wp:attachment":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/media?parent=5341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\u00a0If you want the map palettes to vary based on the visible base geography and its associated data, please see section \u2018Setting Custom Legends<\/a>\u2019 in the Excel Data Manager area or section 3.8.2 of the Access Data Manager User Guide<\/a>.<\/p>\n\n
![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2021\/12\/Nolocaldatafilenothemefile.png\")
<\/a><\/p>\n![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2019\/05\/IAMergeFiles.png\")
<\/a><\/p>\n![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2021\/12\/123.png\")
<\/a><\/p>\n![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2021\/12\/Createlocalfile.png\")
<\/a><\/p>\n