A1Administration Tool培训资料.docx

A1Administration Tool培训资料.docx

《A1Administration Tool培训资料.docx》由会员分享，可在线阅读，更多相关《A1Administration Tool培训资料.docx（92页珍藏版）》请在冰豆网上搜索。

A1AdministrationTool培训资料

A1-AdministrationTool

CreatingaRepositoryUsingtheOracleBusinessIntelligenceAdministrationTool

Purpose

ThistutorialcoversusingtheOracleBusinessIntelligence（BI）AdministrationTooltobuild,modify,enhance,andmanageanOracleBIrepository.

Overview

ThistutorialshowsyouhowtobuildanOracleBImetadatarepositoryusingtheOracleBIAdministrationTool.Youlearnhowtoimportmetadatafromdatabasesandotherdatasources,simplifyandreorganizetheimportedmetadataintoabusinessmodel,andthenstructurethebusinessmodelforpresentationtouserswhorequestbusinessintelligenceinformationviaOracleBIuserinterfaces.

BuildingthePhysicalLayerofaRepository

CreateaNewRepository

1.

Select Start>Programs>OracleBusinessIntelligence>BIAdministration toopentheAdministrationTool.

2.

Select File>NewRepository.

3.

Enteranamefortherepository.Inthistutorialtherepositorynameis BISAMPLE.

4.

Leavethedefaultlocationasis.Itpointstothedefaultrepositorydirectory.

5.

LeaveImportMetadatasetto Yes.

6.

Enterandretypeapasswordfortherepository.Inthistutorial BISAMPLE istherepositorypassword.

7.

Click Next.

ImportMetadata

1.

ChangetheConnectionTypeto OCI10g/11g.Thescreendisplaysconnectionfieldsbasedontheconnectiontypeyouselected.

2.

Enteradatasourcename.Inthisexamplethedatasourcenameis orcl.Thisnameisthesameasthetnsnames.oraentryforthisOracledatabaseinstance.

3.

Enterausernameandpasswordforthedatasource.InthisexampletheusernameandpasswordarebothBISAMPLE.RecallthatBISAMPLEisthenameoftheuser/schemayoucreatedintheprerequisitesection.

4.

Click Next.

5.

Acceptthedefaultmetadatatypesandclick Next.

6.

IntheDatasourceview,expandthe BISAMPLE schema.

7.

Use Ctrl+Click toselectthefollowingtables:

SAMP_ADDRESSES_D

SAMP_CUSTOMERS_D 

SAMP_PRODUCTS_D

SAMP_REVENUE_F

SAMP_TIME_DAY_D

8.

Clickthe ImportSelectedbutton toaddthetablestotheRepositoryView.

9.

TheConnectionPooldialogboxappears.Acceptthedefaultsandclick OK.

10.

TheImportingmessageappears.

11.

Whenimportiscomplete,expand BISAMPLE intheRepositoryViewandverifythatthefivetablesarevisible.

12.

Click Finish toopentherepository.

13.

Expand orcl>BISAMPLE andconfirmthatthefivetablesareimportedintothePhysicallayeroftherepository.

VerifyConnection

1.

Select Tools>UpdateAllRowCounts.

2.

Whenupdaterowcountscompletes,movethecursoroverthetablesandobservethatrowcountinformationisnowvisible,includingwhentherowcountwaslastupdated.

3.

Expandtablesandobservethatrowcountinformationisalsovisibleforindividualcolumns.

4.

Right-clickatableandselect ViewData toviewthedataforthetable.

5.

ClosetheViewDatadialogboxwhenyouaredone.Itisagoodideatoupdaterowcountsorviewdataafteranimporttoverifyconnectivity.Viewingdataorupdatingrowcount,ifsuccessful,tellsyouthatyourconnectionisconfiguredcorrectly.

CreateAliases

1.

ItisrecommendedthatyouusetablealiasesfrequentlyinthePhysicallayertoeliminateextraneousjoinsandtoincludebestpracticenamingconventionsforphysicaltablenames.Right-click SAMP_TIME_DAY_D andselectNewObject>Alias toopenthePhysicalTabledialogbox.

2.

Enter D1Time intheNamefield.

3.

IntheDescriptionfield,enter TimeDimensionAliasatdaygrain.Storesonerecordforeachday.

4.

Clickthe Columns tab.Notethataliastablesinheritallcolumndefinitionsfromthesourcetable.

5.

Click OK toclosethePhysicalTabledialogbox.

6.

Repeatthestepsandcreatethefollowingaliasesfortheremainingphysicaltables.

SAMP_ADDRESSES_D= D4Address

SAMP_CUSTOMERS_D= D3Customer

SAMP_PRODUCTS_D= D2Product

SAMP_REVENUE_F= F1Revenue

CreateKeysandJoins

1.

SelectthefivealiastablesinthePhysicallayer.

2.

Right-clickoneofthehighlightedaliastablesandselect PhysicalDiagram>SelectedObject（s）Only toopenthePhysicalDiagram.Alternatively,youcanclickthePhysicalDiagrambuttononthetoolbar.

3.

Rearrangethealiastableobjectssotheyareallvisible.Ifdesired,right-clickinthewhitespaceofthediagramandselectZoomtochangethesizeoftheobjectsinthePhysicalDiagram.

4.

Clickthe NewForeignKey buttononthetoolbar.

5.

Clickthe D1Time table,andthenclickthe F1Revenue table.ThePhysicalForeignKeydialogboxopens.Itmatterswhichtableyouclickfirst.Thejoincreatesaone-to-many（1:

N）relationshipthatjoinsthekeycolumninthefirsttabletoaforeignkeycolumninthesecondtable.

6.

Selectthe D1Time.CALENDAR_DATE column,andthenselect F1Revenue.BILL_DAY_DT tojointhetables.EnsurethattheExpressioneditbox（atthebottom）containsthefollowingexpression:

"orcl".""."BISAMPLE"."D1Time"."CALENDAR_DATE"="orcl".""."BISAMPLE"."F1Revenue"."BILL_DAY_DT"

7.

Click OK toclosethePhysicalForeignKeydialogbox.ThejoinisvisibleinthePhysicalDiagram.

8.

Repeatthestepstocreatejoinsfortheremainingtables.Usethefollowingexpressionsasaguide:

"orcl".""."BISAMPLE"."D2Product"."PROD_KEY"="orcl".""."BISAMPLE"."F1Revenue"."PROD_KEY"

"orcl".""."BISAMPLE"."D4Customer"."CUST_KEY"="orcl".""."BISAMPLE"."F1Revenue"."CUST_KEY"

"orcl".""."BISAMPLE"."D5Address"."ADDRESS_KEY"="orcl".""."BISAMPLE"."D4Customer"."ADDRESS_KEY"

9.

Clickthe X intheupperrightcornertoclosethePhysicalDiagram.

10.

Select File>Save orclickthe Save buttononthetoolbartosavetherepository.

11.

Click No whenpromptedtocheckglobalconsistency.CheckingGlobalConsistencychecksforerrorsintheentirerepository.SomeofthemorecommonchecksaredoneintheBusinessModelandMappinglayerandPresentationlayer.Sincetheselayersarenotdefinedyet,bypassthischeckuntiltheotherlayersintherepositoryarebuilt.Youlearnmoreaboutconsistencychecklaterinthistutorial.

12.

LeavetheAdministrationToolandtherepositoryopenforthenexttopic.

Congratulations!

Youhavesuccessfullycreatedanewrepository,importedatableschemafromanexternaldatasourceintothePhysicallayer,createdaliases,anddefinedkeysandjoins.

InthenexttopicyoulearnhowtobuildtheBusinessModelandMappinglayerofarepository.

BuildingtheBusinessModelandMappingLayerofaRepository

CreateaBusinessModel

1.

Right-clickthewhitespaceintheBusinessModelandMappinglayerandselect NewBusinessModel toopentheBusinessModeldialogbox.

2.

Enter SampleSales intheNamefield.Leave Disabled checked.

3.

Click OK.TheSampleSalesbusinessmodelisaddedtotheBusinessModelandMappinglayer.

4.

InthePhysicallayer,selectthefollowingfouraliastables:

D1Time

D2Product

D3Customer

F1Revenue

Donotselect D4Address atthistime.

5.

DragthefouraliastablefromthePhysicallayertothe SampleSales businessmodelintheBusinessModelandMappinglayer.ThetablesareaddedtotheSampleSalesbusinessmodel.Noticethatthethreedimensiontableshavethesameicon,whereastheF1Revenuetablehasaniconwitha#sign,indicatingitisafacttable.

ExamineLogicalJoins

1.

Right-clickthe SampleSales businessmodelandselect BusinessModelDiagram>WholeDiagram toopentheBusinessModelDiagram.

2.

Ifnecessary,rearrangetheobjectssothatthejoinrelationshipsarevisible.

BecauseyoudraggedalltablessimultaneouslyfromthePhysicallayerontothebusinessmodel,thelogicalkeysandjoinsarecreatedautomaticallyinthebusinessmodel.ThisisbecausethekeysandjoinrelationshipswerealreadycreatedinthePhysicallayer.However,youtypicallydonotdragallphysicaltablessimultaneously,exceptinverysimplemodels.Laterinthistutorial,youlearnhowtomanuallybuildlogicalkeysandjoinsintheBusinessModelandMappinglayer.TheprocessisverysimilartobuildingjoinsinthePhysicallayer.

3.

Double-clickanyoneofthejoinsinthediagramtoopentheLogicalJoindialogbox.InthisexamplethejoinbetweenD1TimeandF1Revenueisselected.

Noticethatthereisnojoinexpression.JoinsintheBMMlayerarelogicaljoins.Logicaljoinsexpressthecardinalityrelationshipsbetweenlogicaltablesandarearequirementforavalidbusinessmodel.SpecifyingthelogicaltablejoinsisrequiredsothatOracleBIServerhasnecessarymetadatatotranslatelogicalrequestsagainstthebusinessmodelintoSQLqueriesagainstthephysicaldatasources.LogicaljoinshelpOracleBIServerunderstandtherelationshipsbetweenthevariouspiecesofthebusinessmodel.WhenaqueryissenttoOracleBIServer,theserverdetermineshowtoconstructphysicalqueriesbyexamininghowthelogicalmodelisstructured.Examininglogicaljoinsisanintegralpartofthisprocess.TheAdministrationToolconsidersatabletobealogicalfacttableifitisatthe“many”endofalllogicaljoinsthatconnectittootherlogicaltables.

4.

Click OK toclosetheLogicalJoindialogbox.

5.

Clickthe X toclosetheBusinessModelDiagram.

ExamineLogicalColumns

1.

Expandthe D1Time logicaltable.NoticethatlogicalcolumnswerecreatedautomaticallyforeachtablewhenyoudraggedthealiastablesfromthePhysicallayertotheBMMlayer.

ExamineLogicalTableSources

1.

Expandthe Sources folderforthe D1Time logicaltable.Noticethere