1、Transitive Attribute,reed lei 2010/02/04,2/11,Agenda,Why to use Navigation Attribute How to use Navigation Attribute What is Transitive Attribute How to change Transitive Attribute How to update Attribute,3/11,Why to use Navigation Attribute,Characteristic不在實務中,但是卻是我們分析的對象,比如料號類別。 Characteristic有在實務
2、中,但卻是一個不穩定的或是附屬的,比如料號名稱。注:Characteristic A為 Characteristic B的 Attribute的前提是A與B的關係是多對一。,4/11,How to use Navigation Attribute,change attribute to navigation attribute,5/11,How to use Navigation Attribute,turn on the navigation attribute in cube,6/11,What is Transitive Attribute,通俗的講就是屬性的屬性,7/11,How to
3、 change Transitive Attribute,三層變兩層-拉近關係,1. Create a new Characteristics dA like A , add T2 as attribute Including the dA in the cube Adjust the update rule,8/11,How to change Transitive Attribute,Create a new Characteristics dA like A , add T2 as attributeIncluding the dA in the cubeAdjust the update rule (update A and dA with the same data)Create New infosources to update A and dA with A datasource,9/11,How to update Attribute,non-delta-enabled extractor,10/11,How to update Attribute,delta-enabled extractor,11/11,謝謝你的關注,