A1-Administration-Tool培训资料.doc
《A1-Administration-Tool培训资料.doc》由会员分享,可在线阅读,更多相关《A1-Administration-Tool培训资料.doc(88页珍藏版)》请在咨信网上搜索。
1、A1-Administration Tool精品文档Creating a Repository Using the Oracle Business Intelligence Administration ToolPurposeThis tutorial covers using the Oracle Business Intelligence (BI) Administration Tool to build, modify, enhance, and manage an Oracle BI repository.OverviewThis tutorial shows you how to b
2、uild an Oracle BI metadata repository using the Oracle BI Administration Tool. You learn how to import metadata from databases and other data sources, simplify and reorganize the imported metadata into a business model, and then structure the business model for presentation to users who request busi
3、ness intelligence information via Oracle BI user interfaces.Building the Physical Layer of a RepositoryCreate a New Repository1.SelectStart Programs Oracle Business Intelligence BI Administrationto open the Administration Tool. 2.SelectFile New Repository.3.Enter a name for the repository. In this t
4、utorial the repository name isBISAMPLE.4.Leave the default location as is. It points to the default repository directory.5.Leave Import Metadata set toYes.6.Enter and retype a password for the repository. In this tutorialBISAMPLEis the repository password.7 .ClickNext.Import Metadata1 .Change the Co
5、nnection Type toOCI 10g/11g. The screen displays connection fields based on the connection type you selected.2 .Enter a data source name. In this example the data source name isorcl. This name is the same as the tnsnames.ora entry for this Oracle database instance.3 .Enter a user name and password f
6、or the data source. In this example the username and password are bothBISAMPLE. Recall that BISAMPLE is the name of the user/schema you created in the prerequisite section.4 .ClickNext.5 .Accept the default metadata types and clickNext.6 .In the Data source view, expand theBISAMPLEschema.7 .UseCtrl+
7、Clickto select the following tables:SAMP_ADDRESSES_DSAMP_CUSTOMERS_DSAMP_PRODUCTS_DSAMP_REVENUE_FSAMP_TIME_DAY_D8 .Click theImport Selected buttonto add the tables to the Repository View.9 .The Connection Pool dialog box appears. Accept the defaults and clickOK.10 .The Importing message appears.11 .
8、When import is complete, expandBISAMPLEin the Repository View and verify that the five tables are visible.12 .ClickFinishto open the repository.13 .Expandorcl BISAMPLEand confirm that the five tables are imported into the Physical layer of the repository.Verify Connection1 .SelectTools Update All Ro
9、w Counts.2 .When update row counts completes, move the cursor over the tables and observe that row count information is now visible, including when the row count was last updated.3 .Expand tables and observe that row count information is also visible for individual columns.4 .Right-click a table and
10、 selectView Datato view the data for the table.5 .Close the View Data dialog box when you are done. It is a good idea to update row counts or view data after an import to verify connectivity. Viewing data or updating row count, if successful, tells you that your connection is configured correctly.Cr
11、eate Aliases1 .It is recommended that you use table aliases frequently in the Physical layer to eliminate extraneous joins and to include best practice naming conventions for physical table names. Right-clickSAMP_TIME_DAY_Dand selectNew Object Aliasto open the Physical Table dialog box.2 .EnterD1 Ti
12、mein the Name field.3 .In the Description field, enterTime Dimension Alias at day grain. Stores one record for each day.4 .Click theColumnstab. Note that alias tables inherit all column definitions from the source table.5 .ClickOKto close the Physical Table dialog box.6 .Repeat the steps and create
13、the following aliases for the remaining physical tables.SAMP_ADDRESSES_D =D4 AddressSAMP_CUSTOMERS_D =D3 CustomerSAMP_PRODUCTS_D =D2 ProductSAMP_REVENUE_F =F1 RevenueCreate Keys and Joins1 .Select the five alias tables in the Physical layer.2 .Right-click one of the highlighted alias tables and sele
14、ctPhysical Diagram Selected Object(s) Onlyto open the Physical Diagram. Alternatively, you can click the Physical Diagram button on the toolbar.3 .Rearrange the alias table objects so they are all visible. If desired, right-click in the white space of the diagram and select Zoom to change the size o
15、f the objects in the Physical Diagram.4 .Click theNew Foreign Keybutton on the toolbar.5 .Click theD1 Timetable, and then click theF1 Revenuetable. The Physical Foreign Key dialog box opens. It matters which table you click first. The join creates a one-to-many (1:N) relationship that joins the key
16、column in the first table to a foreign key column in the second table.6 .Select theD1 Time. CALENDAR_DATEcolumn, and then selectF1 Revenue.BILL_DAY_DTto join the tables. Ensure that the Expression edit box (at the bottom) contains the following expression:orcl.BISAMPLE.D1 Time.CALENDAR_DATE = orcl.B
17、ISAMPLE.F1 Revenue.BILL_DAY_DT7 .ClickOKto close the Physical Foreign Key dialog box. The join is visible in the Physical Diagram.8 .Repeat the steps to create joins for the remaining tables. Use the following expressions as a guide:orcl.BISAMPLE.D2 Product.PROD_KEY = orcl.BISAMPLE.F1 Revenue.PROD_K
18、EYorcl.BISAMPLE.D4 Customer.CUST_KEY = orcl.BISAMPLE.F1 Revenue.CUST_KEYorcl.BISAMPLE.D5 Address.ADDRESS_KEY = orcl.BISAMPLE.D4 Customer.ADDRESS_KEY9 .Click theXin the upper right corner to close the Physical Diagram.10 .SelectFile Saveor click theSavebutton on the toolbar to save the repository.11
19、.ClickNowhen prompted to check global consistency. Checking Global Consistency checks for errors in the entire repository. Some of the more common checks are done in the Business Model and Mapping layer and Presentation layer. Since these layers are not defined yet, bypass this check until the other
20、 layers in the repository are built. You learn more about consistency check later in this tutorial.12 .Leave the Administration Tool and the repository open for the next topic.Congratulations! You have successfully created a new repository, imported a table schema from an external data source into t
21、he Physical layer, created aliases, and defined keys and joins.In the next topic you learn how to build the Business Model and Mapping layer of a repository.Building the Business Model and Mapping Layer of a RepositoryCreate a Business Model1.Right-click the white space in the Business Model and Map
22、ping layer and selectNew Business Modelto open the Business Model dialog box.2.EnterSample Salesin the Name field. LeaveDisabledchecked.3.ClickOK. The Sample Sales business model is added to the Business Model and Mapping layer.4.In the Physical layer, select the following four alias tables:D1 TimeD
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- A1 Administration Tool 培训资料
1、咨信平台为文档C2C交易模式,即用户上传的文档直接被用户下载,收益归上传人(含作者)所有;本站仅是提供信息存储空间和展示预览,仅对用户上传内容的表现方式做保护处理,对上载内容不做任何修改或编辑。所展示的作品文档包括内容和图片全部来源于网络用户和作者上传投稿,我们不确定上传用户享有完全著作权,根据《信息网络传播权保护条例》,如果侵犯了您的版权、权益或隐私,请联系我们,核实后会尽快下架及时删除,并可随时和客服了解处理情况,尊重保护知识产权我们共同努力。
2、文档的总页数、文档格式和文档大小以系统显示为准(内容中显示的页数不一定正确),网站客服只以系统显示的页数、文件格式、文档大小作为仲裁依据,平台无法对文档的真实性、完整性、权威性、准确性、专业性及其观点立场做任何保证或承诺,下载前须认真查看,确认无误后再购买,务必慎重购买;若有违法违纪将进行移交司法处理,若涉侵权平台将进行基本处罚并下架。
3、本站所有内容均由用户上传,付费前请自行鉴别,如您付费,意味着您已接受本站规则且自行承担风险,本站不进行额外附加服务,虚拟产品一经售出概不退款(未进行购买下载可退充值款),文档一经付费(服务费)、不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
4、如你看到网页展示的文档有www.zixin.com.cn水印,是因预览和防盗链等技术需要对页面进行转换压缩成图而已,我们并不对上传的文档进行任何编辑或修改,文档下载后都不会有水印标识(原文档上传前个别存留的除外),下载后原文更清晰;试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓;PPT和DOC文档可被视为“模板”,允许上传人保留章节、目录结构的情况下删减部份的内容;PDF文档不管是原文档转换或图片扫描而得,本站不作要求视为允许,下载前自行私信或留言给上传者【精***】。
5、本文档所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用;网站提供的党政主题相关内容(国旗、国徽、党徽--等)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
6、文档遇到问题,请及时私信或留言给本站上传会员【精***】,需本站解决可联系【 微信客服】、【 QQ客服】,若有其他问题请点击或扫码反馈【 服务填表】;文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“【 版权申诉】”(推荐),意见反馈和侵权处理邮箱:1219186828@qq.com;也可以拔打客服电话:4008-655-100;投诉/维权电话:4009-655-100。