Microsoft SQL Server 2008 R2 Dokumentacja Pobierz pdf (Strona 150)

130 CHAPTER 7 Master Data Services

An entity can also have any number of domain-based attributes whose values are mem-

bers of another related entity. In the example in Figure 7-1, the ProductSubCategory attribute

is a domain-based attribute. That is, the ProductSubCategory codes are attribute values in the

Product entity, and they are also members of the ProductSubCategory entity. A third type of

attribute is the le attribute, which you can use to store a le or image.

You have the option to organize attributes into attribute groups. Each attribute group con-

tains the name and code attributes of the entity. You can then assign the remaining attributes

to one or more attribute groups or not at all. Attribute groups are securable objects.

You can organize members into hierarchies. Figure 7-2 shows partial data from two types

of hierarchies. On the left is an explicit hierarchy, which contains all members of a single enti-

ty. On the right is a derived hierarchy, which contains members from multiple, related entities.

FIGURE 7-2 Product hierarchies

In the explicit hierarchy, you create consolidated members to group the leaf members. For

example, in the Geography hierarchy shown in Figure 7-2, North America, United States, and

Bikes are all consolidated members that create multiple levels for summarization of the leaf

members.

In a derived hierarchy, the domain-based attribute values of an entity dene the levels. For

example, in the Category hierarchy in the example, Wholesale is in the ProductGroup entity,

which in turn is a domain-based attribute of the ProductCategory entity of which Compo-

nents is a member. Likewise, the ProductCategory entity is a domain-based attribute of the

ProductSubCategory entity, which contains Forks as a member. The base entity, Product,

includes ProductSubCategory as a domain-based attribute.

Regardless of hierarchy type, each hierarchy contains all members of the associated enti-

ties. When you add, change, or delete a member, all hierarchies to which the member belongs

will also update to maintain consistency across hierarchies.

A collection is an alternative way to group members by selecting nodes from existing

explicit hierarchies, as shown in Figure 7-3. Although this example shows only leaf members,

a collection can also contain branches of consolidated members and leaf members. You can

combine nodes from multiple explicit hierarchies into a single collection, but all members

must belong to the same entity.

1 2 ... 145 146 147 148 149 150 151 152 153 154 155 ... 235 236

Komentarze do niniejszej Instrukcji

Brak uwag

Modely	Typ Dokumentu
CF-VDM732U	Uživatelský manuál Panasonic CF-VDM732U User Manual, 96 stránky
2SD0592A	Uživatelský manuál Panasonic 2SD0592A User Manual, 4 stránky
2SC5950	Uživatelský manuál Panasonic 2SC5950 User Manual, 2 stránky
Light Emitting Diodes LN222RPX	Uživatelský manuál Panasonic Light Emitting Diodes LN222RPX User Manual, 3 stránky
Light Emitting Diodes SHD00736AEK	Uživatelský manuál Panasonic Light Emitting Diodes SHD00736AEK User Manual, 3 stránky
MA271110G	Uživatelský manuál Panasonic MA271110G User Manual, 4 stránky
MA22D28	Uživatelský manuál Panasonic MA22D28 User Manual, 3 stránky
LN39GPX	Uživatelský manuál Panasonic LN39GPX User Manual, 3 stránky
AW-PB302	Uživatelský manuál Panasonic AW-PB302 User Manual, 14 stránky
KX-TGA575	Uživatelský manuál Panasonic KX-TGA575 User Manual, 24 stránky
Circuit Protector Elements UNHZ203	Uživatelský manuál Panasonic Circuit Protector Elements UNHZ203 User Manual, 3 stránky
2SC6036G	Uživatelský manuál Panasonic 2SC6036G User Manual, 4 stránky
2SA2174G	Uživatelský manuál Panasonic 2SA2174G User Manual, 4 stránky
ET-RMRC2	Uživatelský manuál Panasonic ET-RMRC2 User Manual [en] , 1 stránky
MA24D58	Uživatelský manuál Panasonic MA24D58 User Manual, 3 stránky
2SA1748	Uživatelský manuál Panasonic 2SA1748 User Manual, 3 stránky
2SA1309A	Uživatelský manuál Panasonic 2SA1309A User Manual, 3 stránky
KX-HGC200	Uživatelský manuál Panasonic KX-HGC200 User Manual, 80 stránky
AJ-CA910P	Uživatelský manuál Panasonic AJ-CA910P User Manual, 9 stránky
P2HD AJ-HRW10G	Uživatelský manuál Panasonic P2HD AJ-HRW10G User Manual, 48 stránky

Microsoft SQL Server 2008 R2 Dokumentacja Strona 150

Komentarze do niniejszej Instrukcji

Panasonic BL-PA300A manuály

Panasonic BL-PA300A Uživatelský manuál (56 strany)

Tabulka s obsahem

Další produkty a příručky pro Hardware Panasonic