内容cognos培训建行c8t

1、Maintain Models and PowerCubesCognos 8 BIObjectivesAt the end of this course, you should be able to:maintain models and PowerCubesunderstand data source, model, cube updatessynchronize the model and data sourceincrementally update PowerCubes describe model types and data entitiesdefine members and m

2、ember unique namesaddress changes that Impact a MUNMaintain Models and PowerCubesRespond to: the evolving needs of your report userschanges in your dataor reorganizations in the workplace.Source Data UpdatesFor example:reordering columnsrenaming columns switching to a new data source typeData Source

3、 MaintenanceTransformer data source definitions may require periodic updates or modifications to reflect changes in the actual data source.Updates are required primarily to add new data to the data source for inclusion in the application.Structural changes can also be made to the data source, for ex

4、ample, adding, deleting, re-ordering, or renaming columns.Synchronize the Model and Data SourceThe Modify Columns command is used if structural changes are made to the data source. Transformer recognizes that the columns in the data source no longer match those currently available in the model.Demo

5、1Match the Model based on Source FilesModel Updatesprevent Transformer from adding unwanted categories periodically clean up fragments that can cause generation errors remove categories that are not usedDelete Inactive CategoriesActive category: has been created, updated, moved, or had its propertie

6、s changed after a specified date.delete inactive categories that are no longer needed in your model.ManuallyClean HouseCube UpdatesYou should alert your report users whenever you change a cube object, because the change may not be obvious when they look at the report. You can fully rebuild a cubeinc

7、rementally updateUpdate Cubes Incrementally reduce build times. adds new data without having to re-create the entire PowerCube.A large cube build can be followed by incremental builds such as in period adjustments, which contain a small number of records.Check for Open CubesTransformer automatically

8、 detects if a cube is in use before rebuilding it.At the beginning of the cube re-build, Transformer performs a check to see if the cube is in use.If the cube is open, Transformer warns you that the cube is locked and in use. Demo 2Detect an Open PowerCube During RebuildOverwrite a Published PowerCu

9、be You can also use the Cognos 8 PowerCube Connection Utility to enable, disable, or view the current state of a PowerCube. To overwrite a PowerCube, disable it first. Update Data Source Connection Information After a PowerCube is rebuilt or updated, you can update the data source connection informa

10、tion to point to the newer version of the cube.little to no impact on your Cognos 8 users reports that reference the updated data source connection continue to run and end users begin seeing new cube data Demo 3Overwrite a Published PowerCube Demo 4Update the Data Source Connection, without Impactin

11、g Cognos 8 Users Recover a Failed Model the existence of a .qy? file indicates that Transformer terminated unexpectedly. causes:power failuresprocessing interruptionsModel Types in Cognos 8Cognos 8 lets you work with three model types:relationaldimensionally modeled relational (DMR)OLAPData Entities

12、 in Cognos 8ProductTrailChef Water Bag 1110TrailChef Canteen 2110TrailChef Kitchen Kit 3110Two data entity types:values (relational)members (OLAP and DMR)Product nameAloe Relief Bear Edge Bear Survival EdgeRelationalOLAP/DMRValuesMembersWork with MembersMembers are located in levels of an OLAP or DM

13、R model.DimensionHierarchyLevelMemberChild membersMembers used as data items for a reportWhat Makes Up a Member?Framework Manager DMR sourcemember key = _businessKey (role)member caption = _memberCaption (role)OLAP source (PowerCube)member key = Category code member caption = Category labelOLAP sour

14、ce (MSAS)member key = Member Key Column member caption = Member Name ColumnWhat is a Member Unique Name (MUN)?Used to locate a memberReferenced in an expression when a member is used:in a reportin a filter or calculationfor drill-throughWhat Makes Up a MUN?MUN from a PowerCube data source:great_outd

15、oor_sales_en.Products.Products.Product type-:PC.MEMBER.101MUN from a Framework Manager DMR data source:Sales.Product.Product.Product type-all.2101.101 Changes that Impact a MUNMUNs can change when:hierarchies or levels changemember keys changecategory codes in PowerCubesMember Key Column in MSAS cub

16、es_memberKey role in DMR modelsmembers no longer exist in the data sourcea production environment has more members than in the test environmentDemo 5How Changes to MUNs Impact ReportsConform ValuesIn order to relate information between data sources, values and types must match.Cognos TransformerFramework ManagerDMR_businessKey for Camping Equipment = 1RelationalProduct line code for Camping Equipment = 1Category code for Camping Equipment = 1orSource value for Camping Equipment = 1Conformed values for like dimensionsSummaryAt the end of this course, you sho