[OpenSpending] Doubts about compounds variables and drilldown in levels

José Félix Ontañon fontanon at emergya.com
Sun Jul 22 10:45:40 BST 2012

2012/7/21 Friedrich Lindenberg <friedrich.lindenberg at okfn.org>:
> Dear Jose,
> On Fri, Jul 20, 2012 at 9:16 PM, José Félix Ontañon
> <fontanon at emergya.com> wrote:
>> So, in my dataset[1], 'Spending area' (or 'area') is the level at the
>> top, then 'entity', 'program', and 'concept' as the last level.
>> I'm afraid I don't know how fix the fields, at the dimensions editor,
>> to get that drilldown in three levels behaviour. Which column must be
>> set as id? how do I set the hierarchy area -> entity -> program ->
>> concept?
> OpenSpending doesn't know about hierarchies per se. The links in the
> UK CRA dataset are set in the "Views" config, and I've added a
> configuration similar to that to your dataset. Unfortunately, this
> requires the dimensions to be "Compound Dimensions" (or just
> "Dimensions" in the UI). So you need to drop your data and change the
> model to make entity, program and concept into compound dimensions.
> Let me know if that helps,

Got it! Finally it was a matter of playing with compound dimensions
and views, just as you told me.

Work is done, dataset for the city of Seville is finished.
Thanks Friedrich.

J. Félix Ontañón Carmona
Emergya Consultoría

More information about the openspending mailing list