dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hello,

After working a bit with multidimensionality lately, I remembered this figure:
http://208.76.222.114/confluence/pages/viewpage.action?pageId=950293

Am I right that this is not currently in the documentation (I did not
see it). If not, I can add it.

Also, what is the current thinking regarding multidimensional data in GIS?

Knut

2010/11/15 Knut Staring <knutst@xxxxxxxxx>:
> While we are at it, we could rename the dataelementcategory table to
> just category (though dimension would be even more consistent with
> common OLAP practice, I think). This also makes sense since logically,
> indicators can also be broken down along dimensions, not only
> dataelements, right?
>
> This is not urgent, but if you agree with it, I will be happy to
> create a blueprint and brush up on the documentation of it.
>
> Knut
>
> 2010/11/15 Knut Staring <knutst@xxxxxxxxx>:
>> Ok, I see it now - the combined name is generated based on the names
>> in the dataelementcategoryoption table.
>>
>> I think it could be a bit clearer if we did add that underscore and
>> also if we could rename the dataelementcategoryoption table to just
>> categoryoption, to be consistent with the categories_categoryoptions
>> name.
>>
>> Knut
>>
>> 2010/11/15 Knut Staring <knutst@xxxxxxxxx>:
>>> Sorry, I'm confused. In the db from Malawi, the table is called
>>> categoryoptioncomboname with no underscore in front.
>>>
>>> I also don't quite understand what the bad practice consists in - do
>>> you mean that refactoring (adding the missing name) will break
>>> backwards compatibility?
>>>
>>> Knut
>>>
>>> 2010/11/15 Knut Staring <knutst@xxxxxxxxx>:
>>>> 2010/11/15 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>>>>>
>>>>> Its not categoryoptioncombo but _categoryoptioncombo.  Its a resource table and not part of the model
>>>>
>>>> You mean that it is "_categoryoptioncomboname" and not
>>>> "categoryoptioncomboname", and that this is a resource table, right?
>>>> In other words, a table that gets generated?
>>>>
>>>>> Adding extra columns to domain model tables is bad practice.
>>>>
>>>> Ok, but can you tell me where else the names are stored? In other
>>>> words, how to populate the database directly with hundreds of
>>>> optionscombos?
>>>>
>>>> Knut
>>>>
>>>>> Lars
>>>>>
>>>>> On Mon, Nov 15, 2010 at 3:38 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>>>>
>>>>>> It seems to me this table only serves to hide the name from the
>>>>>> categoryoptioncombo table. Isn't this just adding to the complexity
>>>>>> (and confusion) of the multidiemensional makeup?
>>>>>>
>>>>>> Could we not just add the name to categoryoptioncombo?
>>>>>>
>>>>>> Knut
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Cheers,
>>>> Knut Staring
>>>>
>>>
>>>
>>>
>>> --
>>> Cheers,
>>> Knut Staring
>>>
>>
>>
>>
>> --
>> Cheers,
>> Knut Staring
>>
>
>
>
> --
> Cheers,
> Knut Staring
>



-- 
Cheers,
Knut Staring