文本cognos培训建行c8t-09uniqueness

1、UniquenessCognos 8 BIObjectivesAt the end of this module, you should be able to:identify and resolve conflicts between data sourcesvalidate a multiple data source modeldiscuss a unique moveDirect(yellow)Conflicts in the model (red)Indirect(light yellow)Unrelated(white)identify dimension and level re

2、lationships within a model.Validate Multiple Data Source ModelsDemo 1Data Source ScopeData Source 2 is independent of Data Source 1. How can you ensure that Revenue is rolled up to the Region level?Declare unique to indicate that Employee Code in Data Source 1 is the same as in Data Source 2.Transac

3、tion Data Source 2Employee Code Revenue124 9000125 110850126 57780SStructure Data Source 1Employee Code124125126What is Uniqueness?Staff Name is not unique, therefore you do not know to which City the revenues should roll up.Records from Data Source 2Staff NameRevenueJake Cartel110850Emile Clermont

4、57795 Jake Cartel 45650Records from Data Source 1Staff NameCityJake CartelMelbourne, AustraliaEmile ClermontParis, FranceJake CartelLondon, U.K.Level is Not Unique: The IssueNew columnRecords from Data Source 2Staff Name Rev CityJake Cartel 110850Melbourne, AustraliaEmile Clermont 57795 Paris, Franc

5、eJake Cartel 45650 London, U. K.Level is Not Unique: A SolutionAdd the City column to Data Source 2.Records from Data Source 1Staff Name CityJake Cartel Melbourne, AustraliaEmile Clermont Paris, FranceJake Cartel London, U. K.Declare Levels UniqueYou can prevent model errors caused by changes in the

6、 source data by designating a unique level.A unique level specifies that categories in that level are identified by their source values alone, without reference to their ancestors.Identify Model IssuesThe Check Model command helps you identify: insufficient context levels that cannot be reached in t

7、he current drill-down pathuniqueness issuesan unbalanced category treeDemo 2Declare Levels UniqueDemo 3 (Instructor only) Uniqueness ViolationsUnique Moveensures the category you move within the level has its data history move with itavoids manually restructuring the categories in a dimension when you change the parent category that is tied to a unique levelDemo 4 (Instructor only) Unique MoveSummaryAt the end of this module, you should be