[dbo].[rule_dec_combo

[dbo].[rule_dec_combo_list]

(local) > mdb > Views > dbo.rule_dec_combo_list

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:10 PM Sunday, December 05, 2010
Last Modified	12:32:10 PM Sunday, December 05, 2010

Columns

Name
chart_element_label
dimension_3

Permissions

Type	Action	Owning Principal
Grant	Select	aionadmin_group

SQL Script

CREATE VIEW "rule_dec_combo_list" AS
       SELECT DISTINCT "kpi_data"."chart_element_label", "kpi_data"."dimension_3"
       FROM "kpi_data"
       WHERE kpi_id = 5
GO
GRANT SELECT ON  [dbo].[rule_dec_combo_list] TO [aionadmin_group]
GO

Uses

[dbo].[kpi_data]
dbo