[OpenSpending-discuss] Help with the mapping file - views

Mon Nov 28 16:40:14 UTC 2011

I would like to ask you for help with the mapping file - views. I 
probably still cannot get the idea of drilldowns/taxonomies/cuts/filters 
right. I have tried many settings, reading the wiki and some mapping 
files, but no success with following:

I have a datafile
http://sandbox.openspending.org/dataset/cz_2006-2010_os_2
which has 7 different categories (levels)
1:budget - 2:chapter(=group of organizations) - 3:organization - 4:group 
of entries (e.g. 'salaries') - 5:subgroup of entries - 6:subsubgroup of 
entries - 7:entry(account number) -> amount
e.g.
1:budget - 2:Chapter 311 - 3:Organization X - 4:group 4_1 - 5:subgroup 
5_1 - 6:subsubgroup 6_1 - 7:entry 5111
or
1:budget - 2:Chapter 311 - 3:Organization Y - 4:group 4_1 - 5:subgroup 
5_1 - 6:subsubgroup 6_1 - 7:entry 5111

(mind that spending groups at level 4 till 7 are the same for all the 
organizations)

I want to be able to drilldown (with appropriate filters) _using the 
tree-chart_ (and api)
A) 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 (and get the final amount in given 
year and organization and entry=account)
and/or
B) 1 -> 4 -> 5 -> 6 -> 7 -> 2 -> 3 (or similarly 1 -> 4 -> 2 -> 3 ... )

How shall I specify the mapping file?

Thanks a lot for your help,
Michal
p.s.: It works in desirable manner down to level 3/4 at the 
http://sandbox.openspending.org/dataset/cz_2006-2010_os_2, but I cannot 
get it work well further down to level 6/7

-- 
Mgr. Michal Škop, Ph.D.
KohoVolit.eu
michal.skop at kohovolit.eu
+420 775 187 021 / +420 721 484 915