Creating View Queries

If you generate a Star Schema with the Weights option, create a SQL query using this command to return rows for measures and perspectives on a scorecard:

select * from HPS_STAR_SCORECARD_VIEW where date = 'yyyy-MM-dd' and scorecard_id = id

The result set contains rows for each measure and perspective on that scorecard. For example:

Table 10. Sample View Query

Date	Measure ID	Scorecard ID	Name	Dimensional Measure	Result	Target	Weight	Weighted Score	Score	Status Symbol Name
2006–02–01	4701	4301	Has Results(a)	T	15.0	20.0	0.5	37.5	75.0	Good
2006–02–01	4510	4301	Has Results(b)	T	1	4	0.5.	12.5	0.2	None