I’m using Webi 4.2 Support Pack 7 Patch 4
I realise it’s not possible to merge measures, however …
I’m trying to calculate Z scores for weight-for-age and weight-for-length for about 2,000 under-5-year-old children.
I have added a query (from an excel file) with reference tables from the World Health Organisation in the report, with the expected means and standard deviations of weight for each age (in the case of weight-for-age) and length (for weight-for-length). These are then used to calculate the Z scores, which are a standardised measure to show how far a child is from the expected mean.
That all works fine for weight-for-age, as I can merge the age of the child (a dimension) with the age dimension in the reference table.
However, the variable from the universe holding each child’s length/height is a measure - I can’t do anything about this (I don’t think) - so I can’t merge it with the length dimension in the reference table.
I’ve tried converting the length measure to a dimension, but I can’t merge a declared variable with a dimension.
I changed both the length measure and the length dimension for the reference table to dimension variables, but BI would not let me merge two declared variables.
Is there any other way I can align the two queries so my Z scores can calculate?
I’ve run out of ideas, any help greatly appreciated.
SeamusObstat (BOB member since 2017-04-27)