Warehouse Issues

[Ghislain Hachey]

This is still not working for countries without the district population (e.g. RMI). Even with the fix below (i.e. AND isnull(S.DistrictCode, '') = isnull(POP.dID, '')) we still do not get the population data into the warehouse.classLevelER. That final AND clause is never true as S.DistrictCode does have codes yet there is never any POP.dID.



[Ghislain Hachey]

This discussion below was never addressed the way we want it.

NIR, GIR are calculated in the VERMPAF procedures so for reporting purposes we had to redo all those calculation again for excel prep and also for any JasperReports.

My thinking is based on views being usable in cube presentations, such as pivot tables or tableau, so ratios are better claculated in the presentation, where they will be based on the interactive filtering. e.g. custom fields in Excel pivot tables work this way

I'm fine with that and it is very useful. But I still think it would be good to have a view with the ratios already directly available. This would provide a canonical view from which to compare elsewhere calculated ratios (i.e. pivot tables, presentations, website, etc.). For example, instead of warehouse.EdLevelER

warehouse.EdLevelEnrolmentData (a table with all the raw data as it is now without calculating the ratios useful in the way you intended)
warehouse.EdLevelEnrolmentRatios (a view with the all the actual enrolment ratios that can be used directly in report layer or to compare)

[Ghislain Hachey]

[comment below obsolete. better to use classLevelER tables for the GIR/NIR]

Also from two of your warehouse data tables ([warehouse].[EdLevelER] and [warehouse].[EdLevelERDistrict]) We had to process separately the another set of population columns to get the correct GIR/NIR calculated since your population data in those tables seems to be for the whole education level as oppose to the population at the official primary school-entrance age as required by GIR/NIR. From below you see the raw data from [warehouse].[EdLevelER]. The first red underlined population is good for calculating the GER and NER but not for the GIR, NIR. For that we needed to add the second red underlined population set of columns manually and do our own calculations. Can those be added to the warehouse to make this more straightforward.

[Ghislain Hachey]

Moving this to a single software requirement specifications document and issue #472 for convenience.