J
John
I am working on a performance initiative project with tiers of data.
Conceptually it looks like:
1 Objective
1.1-1.n Measures rolling up to Objective 1
1.1.1 - 1.n.n Targets rolling up to Measures 1,1 - 1.n
In the database there is a table for each tier described above and a field
that relates the parent to the child. (e.g. 1 related to 1.1 and 1.2)
Two additional tables include:
A table of Target Scores (tTargetStatus) which has a number assigned to a
description ("Complete" = -1, "Major issues" = 2, etc.)
A table of Adjectival Ratings (tRatings) ("Satisfactory" = 0, "Good" = 1,
etc.)
Targets (tTargets)are each assigned a score from the tTargetStatus based on
their level of completion.
Measures (tMeasures) are to receive an Adjectival rating (Satisfactory,
Good, Outstanding) based on the average score of the underying targets.
Using a summary query and a report I am currently able to get the average
score for the Measure but really need it to give the adjectival rating based
on this average score.
Objectives (tObjectives) are to receive an Adjectival rating based on the
average adjectival rating of the underlying Measures. So I need the
measures' adjectival ratings "stored" somehow. I am not able accomplish this
at all.
Are there any suggestions regardin how I can automate the roll up
calculations? I understand that tTargetStatus and/or tRatings may have been
a waste of time to build but will live with that.
Thanks
gzxyb
Gzxyb
Conceptually it looks like:
1 Objective
1.1-1.n Measures rolling up to Objective 1
1.1.1 - 1.n.n Targets rolling up to Measures 1,1 - 1.n
In the database there is a table for each tier described above and a field
that relates the parent to the child. (e.g. 1 related to 1.1 and 1.2)
Two additional tables include:
A table of Target Scores (tTargetStatus) which has a number assigned to a
description ("Complete" = -1, "Major issues" = 2, etc.)
A table of Adjectival Ratings (tRatings) ("Satisfactory" = 0, "Good" = 1,
etc.)
Targets (tTargets)are each assigned a score from the tTargetStatus based on
their level of completion.
Measures (tMeasures) are to receive an Adjectival rating (Satisfactory,
Good, Outstanding) based on the average score of the underying targets.
Using a summary query and a report I am currently able to get the average
score for the Measure but really need it to give the adjectival rating based
on this average score.
Objectives (tObjectives) are to receive an Adjectival rating based on the
average adjectival rating of the underlying Measures. So I need the
measures' adjectival ratings "stored" somehow. I am not able accomplish this
at all.
Are there any suggestions regardin how I can automate the roll up
calculations? I understand that tTargetStatus and/or tRatings may have been
a waste of time to build but will live with that.
Thanks
gzxyb
Gzxyb