




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
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
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 江苏江苏省农业科学院经济作物研究所招聘非在编工作人员笔试历年参考题库附带答案详解-1
- 文山云南文山马关县消防救援大队招聘10人笔试历年参考题库附带答案详解-1
- 退伍军人创业汇报
- 八年级生物基础知识竞赛题库
- 车辆事故处理流程
- 财务预算流程步骤
- 酒店管理礼仪培训
- 转型金融的研究意义(8篇)
- 可吸收结扎夹收费标准
- 配煤基础知识
- 教教技术cccp四种教练能力与技巧课件
- 信息时代的地理学与人文地理学创新
- 建筑安全员A证考试题库附答案
- 【教学课件】鸽巢问题整理和复习示范教学课件
- DB1410-T 129-2022园林植物常见病虫害防治技术规范
- 儿科学课件:营养性维生素D缺乏
- 男性乳腺发育护理查房课件
- ZF转向机安装及调整说明教学文稿
- 住房公积金经办人(专管员)登记申请表(2022新版)
- 如何唤醒孩子的内驱力PPT课件
- 叉车年度(首检)自检报告
评论
0/150
提交评论