{"action":"created","issue":{"url":"https://api.github.com/repos/openspending/fiscal-data-package/issues/60","labels_url":"https://api.github.com/repos/openspending/fiscal-data-package/issues/60/labels{/name}","comments_url":"https://api.github.com/repos/openspending/fiscal-data-package/issues/60/comments","events_url":"https://api.github.com/repos/openspending/fiscal-data-package/issues/60/events","html_url":"https://github.com/openspending/fiscal-data-package/issues/60","id":110679114,"number":60,"title":"Different measure columns can reflect different values of a dimension","user":{"login":"danfowler","id":772616,"avatar_url":"https://avatars.githubusercontent.com/u/772616?v=3","gravatar_id":"","url":"https://api.github.com/users/danfowler","html_url":"https://github.com/danfowler","followers_url":"https://api.github.com/users/danfowler/followers","following_url":"https://api.github.com/users/danfowler/following{/other_user}","gists_url":"https://api.github.com/users/danfowler/gists{/gist_id}","starred_url":"https://api.github.com/users/danfowler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danfowler/subscriptions","organizations_url":"https://api.github.com/users/danfowler/orgs","repos_url":"https://api.github.com/users/danfowler/repos","events_url":"https://api.github.com/users/danfowler/events{/privacy}","received_events_url":"https://api.github.com/users/danfowler/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-10-09T15:16:00Z","updated_at":"2015-10-13T23:03:56Z","closed_at":null,"body":"In some datasets (e.g. https://github.com/os-data/eu-allocations-per-ms-2014-2020 & https://github.com/os-data/gb-cap-beneficiaries), different columns refer to spending on different programs/projects.  However, we expect to express programs/projects as values in a dimension.  Should we expect this kind of file (A) to be transformed (more or less \"paste special tranposed\") into the shape we expect (B)?\r\n\r\n### A\r\n\r\n| Country ID | Cohesion Fund (€) | Less Developed Regions (€) | Transition Regions (€) | More Developed Regions (€) | Outermost and northern sparsely populated regions (€) | European Territorial Cooperation: Cross-Border Cooperation (€) | European Territorial Cooperation: Transnational Cooperation (€) | Youth Employment Initiative (additional allocation) (€) | \r\n| --- | --- | --- | --- | --- | --- | --- | --- | --- |\r\n| Poland | 23208000000 | 51163600000 |  | 2242400000 |  | 543200000 | 157300000 | 252400000 |\r\n\r\n### B\r\n\r\n| Country ID | Fund | Amount |\r\n| ------------- | ------------- | ----- | \r\n| Poland | Cohesion Fund (€) | 23208000000 |\r\n| Poland | Less Developed Regions (€) | 51163600000 |\r\n| Poland | More Developed Regions (€) | 2242400000 |\r\n| Poland | European Territorial Cooperation: Cross-Border Cooperation (€) | 543200000 |\r\n| Poland | European Territorial Cooperation: Transnational Cooperation (€) | 157300000 |\r\n| Poland | Youth Employment Initiative (additional allocation) (€) | 252400000 |\r\n"},"comment":{"url":"https://api.github.com/repos/openspending/fiscal-data-package/issues/comments/147878354","html_url":"https://github.com/openspending/fiscal-data-package/issues/60#issuecomment-147878354","issue_url":"https://api.github.com/repos/openspending/fiscal-data-package/issues/60","id":147878354,"user":{"login":"rgrp","id":180658,"avatar_url":"https://avatars.githubusercontent.com/u/180658?v=3","gravatar_id":"","url":"https://api.github.com/users/rgrp","html_url":"https://github.com/rgrp","followers_url":"https://api.github.com/users/rgrp/followers","following_url":"https://api.github.com/users/rgrp/following{/other_user}","gists_url":"https://api.github.com/users/rgrp/gists{/gist_id}","starred_url":"https://api.github.com/users/rgrp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgrp/subscriptions","organizations_url":"https://api.github.com/users/rgrp/orgs","repos_url":"https://api.github.com/users/rgrp/repos","events_url":"https://api.github.com/users/rgrp/events{/privacy}","received_events_url":"https://api.github.com/users/rgrp/received_events","type":"User","site_admin":false},"created_at":"2015-10-13T23:03:56Z","updated_at":"2015-10-13T23:03:56Z","body":"IMO this should *definitely* be normalized. Those columns are *not* IMO measures. So +1 to @pwalsh and perhaps we should have an example for this listing it as anti-pattern and explaining how it should be transformed."}}