Skip to end of metadata
Go to start of metadata

This section shows show sample configuration for simple weighted databases.

Single Fact Table and One Weight

weightings.xml
<DATABASE_WEIGHTINGS dbid="CustomerSurvey2015" formula_file="formulas.xml">
    <WEIGHT id="Person Weight" type="Single" level="Person"/>

    <COEFF measure="Person" weight_id="Person Weight">
        <VAR id="N" value="25814697"/>
        <VAR id="n" value="59053 "/>
    </COEFF>
</DATABASE_WEIGHTINGS>

In this example:

  • The database ID is CustomerSurvey2015.
  • There is only one fact table, Person.
  • There is only one weighting factor. The display name of the measure that contains this weighting factor is Person Weight.
  • The sample size consists of 59,053 records, representing a total population of 25,814,697.

Multiple Fact Tables and Multiple Weights

weightings.xml
<DATABASE_WEIGHTINGS dbid="LabourForceSurvey" formula_file="formulas.xml">
    <WEIGHT id="Family Weight" type="Single" level="Family"/>
    <WEIGHT id="Person Weight" type="Single" level="Person"/>
    <WEIGHT id="Person Income Weight" type="Single" level="Person"/>
    <WEIGHT id="Household Weight" type="Single" level="Household"/>

    <COEFF measure="Person" weight_id="Person Weight">
        <VAR id="N" value="58336835"/>
        <VAR id="n" value="133815 "/>
    </COEFF>

    <COEFF measure="Person" weight_id="Person Income Weight">
        <VAR id="N" value="24161932"/>
        <VAR id="n" value="1469"/>
    </COEFF>

    <COEFF measure="Family" weight_id="Family Weight">
        <VAR id="N" value="26817302"/>
        <VAR id="n" value="60475"/>
    </COEFF>

    <COEFF measure="Household" weight_id="Household Weight">
    <VAR id="N" value="24680901"/>
    <VAR id="n" value="56102"/>
</DATABASE_WEIGHTINGS>

In this example:

  • The database ID is CustomerSurvey2015.
  • There are three fact tables, Person, Family and Household.
  • There are four weighting factors:
    • Person Weight and Person Income Weight are the display names of fields containing weights in the Person fact table.
    • Family Weight is a weight in the Family fact table.
    • Household Weight is a weight in the Household fact table.

Example Formulas File

The following is a simple formulas file defining only Sum, Weighted Sum and Standard Error of Sum:

formulas.xml
<WEIGHTFORMULAS id="type1">
	<TAGS measure="measure" weight="weight" level="level" all="all"/>
	<LABELTEMPLATE expression="%FUNCTION of %MEASURE"/>

	<!-- Sum -->
	<!-- Single Measure Single Weight No Derivation -->
	<FORMULA id="WSUM" name="Weighted Sum" type="SMSWND">
		<UDF id="wx_udf"/>
	</FORMULA>
	<FORMULA id="WRSEDC" name="Standard Error of Sum" type="SMSW" level="true">
		<UDF id="wx_udf"/>
		<UDF id="wxx_udf"/>
		<COEFF>n</COEFF>
		<COEFF>N</COEFF>
		<DER_EXPRESSION>(Sqrt(("wxx_udf" - ("wx_udf"*"wx_udf"/"weight"))/(("weight" - 1) * "level")*"weight"*"weight" + ("N"-"weight")*(1-"n"/"N")*"weight"/"n"))</DER_EXPRESSION>
	</FORMULA>
	<!-- /Sum -->

	<!-- Unweighted Sum -->
	<FORMULA id="UWSUM" name="Unweighted Sum" type="UNW">
		<!-- Single Measure Single Weight -->
	</FORMULA>
	<!-- /Unweighted Sum -->

	<UDF_DEFINITION id="x_udf">
		<UDF_FORMULA>("measure")</UDF_FORMULA>
	</UDF_DEFINITION>
	<UDF_DEFINITION id="w_udf">
		<UDF_FORMULA>("weight")</UDF_FORMULA>
	</UDF_DEFINITION>
	<UDF_DEFINITION id="wx_udf">
		<UDF_FORMULA>("measure"*"weight")</UDF_FORMULA>
	</UDF_DEFINITION>
	<UDF_DEFINITION id="wxx_udf">
		<UDF_FORMULA>("measure"*"measure"*"weight")</UDF_FORMULA>
	</UDF_DEFINITION>
	<UDF_DEFINITION id="ww_udf">
		<UDF_FORMULA>("weight"*"weight")</UDF_FORMULA>
	</UDF_DEFINITION>
</WEIGHTFORMULAS>

 

 

  • No labels