OWB试验手册5.docx
- 文档编号:18150257
- 上传时间:2023-08-13
- 格式:DOCX
- 页数:25
- 大小:809.79KB
OWB试验手册5.docx
《OWB试验手册5.docx》由会员分享,可在线阅读,更多相关《OWB试验手册5.docx(25页珍藏版)》请在冰点文库上搜索。
OWB试验手册5
仓库的部署
一、DeployingtheExternalTable
Todeploythetwoexternaltables,performthefollowingsteps:
1.
Todeploy,youmustlaunchtheControlCenterManager.Fromthe
ToolsmenuControlCenterManager.
TheControlCenterManagerislaunched.TheControlCenterManagerconsoleappearsasshowninthescreenshot.
2.
ObservethatintheControlCenterManagerconsole,youcanaccessthedesignobjectsbasedontheirlocations,becausethenavigationtreeisorganizedonlocations.
Note:
Whenyoucreatelocationsduringthedesignprocess,youcreatelogicaldefinitionsthatarelimitedtomerelythename,type,andversionofthelocation.Whenyouregisterlocations,youspecifytheactualphysicalconnectioninformationthatwillbeusedduringdeploymenttoconnecttothevariousdatasourcesandtargets.
Locationsenableyoutodeploythesamelogicaldesignintomultiplephysicalimplementationswithnochangetothedesign.Forexample,youcancreateandregisteranotherlocationthatpointstoaQAinstanceofyourtargetsystem.Connectorsdefineapathtotransferdatafromonelocationtoanotherlocation.
操作
ExpandEXPENSE_WH_LOCATION,andthenexpandEXPENSE_WH.Ontheright,intheObjectDetailspanel,examinethedesignstatus,deploystatus,andotherdetailsofalltheobjectsthatyoudesignedinpreviouslessons.
3.
Inthenavigationtreeontheleft,expandandselectExternalTables.IntheObjectDetailspanelontheright,checkwhethertheDesignStatusissettoNewforbothexternaltables,EXPENSE_CATEGORIESandEXPENSE_DATA.
ClickDefaultActions(highlightedinthescreenshot)andobservethatDeployActionischangedtoCreate.
Note:
TheDefaultActionsbuttonautomaticallyupdatestheactionfortheobjectsyouselect.Itintelligentlydeterminesthemostappropriateactionbasedonthemetadatadetailsintherepository.Forexample,forobjectswhosedesignstatusissettoNew,theiractionisautomaticallysettoCreate.
4.
Todeploytheselectedexternaltables,fromtheFilemenu,selectDeploy>ToControlCenterorclicktheDeploy
buttononthetoolbar.
YoucanmonitortheprogressofdeploymentintheControlCenterJobspanelonthelowerrightoftheconsole,asshowninthescreenshot.
Thisisyourfirstdeploymentandyouneedtoregisterthetargetlocation.
IntheEditOracleDatabaseLocationwindow,
enterexpense_whasthepassword.ClickTestConnectiontotesttheconnectiontothetargetschema.
Ifconnectionissuccessful,clickOK.
5.
Again,notethatintheControlCenterJobspanel,thedeploymentstatuschangesfrom"generate"
to"run"
to"completedsuccessfully"
.NotethatDeployStatushaschangedtoSuccessforbothexternaltables.
Youcanviewthegeneratedcodeforthesuccessfullydeployedexternaltables.Double-clickOWB_DEMOintheJobcolumnintheControlCenterJobspanel(highlightedinthescreenshot).
IntheOWB_DEMOdialogbox,clicktheScripttab(highlightedinthescreenshot).Notethatforeachexternaltable,WarehouseBuildergeneratesDDLscripts.ToviewthegeneratedcodefortheExpense_Categoriesexternaltable,selectExpense_Categories.TheViewcodebuttonisenabled.
ClickViewCode.
ScrollintheExpense_Categories.ddlwindowtoviewthegeneratedcode.
FromtheCodemenu,selectClosetoclosethecodewindow.IntheOWB_DEMOdialogbox,selectClosefromtheFilemenutoclosethedialogbox.
YouhavenowsuccessfullydeployedthetwoexternaltablestotheEXPENSE_WHschema.
二、DeployingtheCubeandtheReferencedDimensions
Inthefollowingsteps,youdeploytheREL_EXPENSEcubewiththetwodimensionsREL_CATEGORYandREL_TIME.
1.
Beforeyoudeploythedimensionsandthecube,youneedtodeploytherelationaltablesandsequencesthatthesedimensionsandcubearebasedon.
InEXPENSE_WH,expandTables.ExpandSequences.Todeployallthetablesandsequences,selectTables,pressandhold[Ctrl],andselectSequences.
ObservetheDesignStatusofthethreetablesandtwosequences.
2.
ClickDefaultActionstosetDeployActiontoCreate.FromtheFilemenu,selectDeploy>ToControlCenterorclicktheDeploy
buttononthetoolbar.
IntheControlCenterJobspanel,monitorthedeploymentprogress.Thedeploymentissuccessful.
4.
Youcannowdeploythecube.Beforethecubeisdeployed,youshouldhavedeployedtherelateddimensions.
Beforeyoudeploythedimensionsandthecube,ensurethatthedeploymentoptionissettoDeploytoCatalogOnly.Tosetthedeploymentoptions,
right-clicktheappropriatedimensionorcubeinthedesigncenterandselectConfigurefromthemenu.IntheConfigurationPropertiesdialogbox,setthedeploymentoptionspropertytoDeploytoCatalogOnly.ThescreenshotshowsConfigurationPropertiesdialogboxforREL_EXPENSEcube.
Note:
OracleWarehouseBuilderprovidesfourdeploymentoptionsfordimensionalobjects:
注:
OracleBIWarehouseBuilder为维度对象提供了四个部署选项。
DeployAll:
这是默认的部署选项。
在关系实施中,维度对象将部署到
WarehouseBuilder信息库和OLAP目录中。
DeployDataObjectsOnly:
仅将维度对象部署到WarehouseBuilder
信息库中。
您只能为具有关系实施的维度对象选择此选项。
因为
DataViewer使用OLAP目录元数据来显示数据,所以在使用此选项
部署对象时,您无法通过DataViewer查看加载的数据。
DeploytoCatalogOnly:
仅将维度对象部署到OLAP目录中。
使用此
选项时,您可以在DataViewer中查看加载到维和多维数据集中的数据。
DeployAggregation:
部署多维数据集度量上定义的聚合。
此选项只能用于多维数据集。
InEXPENSE_WH,expandandselectDimensions.ObservethatDesignStatusforalltheobjectsissettoNew.ClickDefaultActionstochangeDeployActiontoCreate.
Todeploy,selectDeploy>ToControlCenterfromtheFilemenu,orclicktheDeploy
button.
NotethatintheControlCenterJobspanel,thedeploymentstatuschangesfrom"generate"to"run"to"completedsuccessfully."
5.
InEXPENSE_WH,expandandselectCubes.NotethatDesignStatusforalltheobjectsissettoNew.ClickDefaultActionstochangeDeployActiontoCreate.
Todeploy,selectDeploy>ToControlCenterfromtheFilemenu,orclicktheDeploy
button.
Again,notethatintheControlCenterJobspanel,thedeploymentstatuschangesfrom"generate"to"run"to"completedsuccessfully."
TheREL_EXPENSEcubeandtheREL_TIMEandREL_CATEGORYdimensionsaresuccessfullydeployed.
三、DeployingtheMappings
Youhavedeployedtheexternaltables,thedimensions,andthecube,younowdeploytheETLmappings.Whenyoudeployamapping,WarehouseBuildergeneratesappropriatescripts.Formappings,youneedtofollowanextrastepofexecutingthesescriptstoactuallyperformETLfromthesourcetothetargets.
Youwillexecutethemappingsinthenextlesson.Thestepstodeploythemappingsaresimilartothosethatyouperformedearlier.
1.
InEXPENSE_WH_LOCATION,selectMappings.IntheObjectDetailspanel,threemappingsareselectedwithDesignStatussettoNew.
2.
ClickDefaultActionstochangeDeployActionfromNonetoCreate.FromtheFilemenu,selectDeploy>ToControlCenterorclicktheDeploy
button.
IntheControlCenterJobspanel,thedeploymentstatuschangesfrom"generate"to"run"to"completedsuccessfully."Themappingsaredeployedsuccessfullyandarereadyforexecution.Toviewthegeneratedcodeforthemapping,double-clicktheOWB_DEMOjobintheControlCenterJobspanel(highlightedinthescreenshot).
3.
IntheOWB_DEMOdialogbox,clicktheScripttab.
NotethatWarehouseBuildergeneratesa.pls(PL/SQL)codeforeachofthedeployedmappings.ToviewthegeneratedcodeforREL_CATEGORY_MAP,selectREL_CATEGORY_MAPandclickViewCode.
Scrolldowninthecodewindowtoexaminethegeneratedcode.
FromCodemenu,selectClose.ThenintheJobDetailswindow,fromFilemenu,clickClosetoexit.
四、DeployingtheProcessFlow
Inthepreviouslesson,youdesignedaprocessflowthatautomatestheexecutionofthemappingsforloadingthetargetdimensionsandthecube.
Youneedtodeploytheprocessflow,beforeitcanbeexecutedtotriggertheexecutionofthedeployedmappings.Todeploytheprocessflow,performthefollowingsteps:
1.
ExpandWH_OWF_LOCATION>MY_PF_MODULE>PK.SelectPK.
IntheObjectDetailspanel,theprocessflowpackagePKisselectedfordeployment.DesignStatusissettoNew.ClickDefaultActionstosetDeployActiontoCreate.
Note:
Youdeploytheprocessflowpackage,andnottheprocessflow.However,youexecutetheprocessflow.
FromtheFilemenu,selectDeploy>ToControlCenterorclicktheDeploy
button.
Theprocessflowpackage,PK,isdeployedsuccessfully.
Note:
Whiledeployingtheprocessflowpackageifyougettheerror,"RPE-02072:
OracleWorkflowNLSlanguage...hasnotbeenenabledintheOracleWorkflowrepository.PleaseenableusingtheOracleWorkflowwfnlena.sqlserver-sidescript.",youneedtoruntwoscriptsinordertoenableandloadtheNLSlanguage,requiredbytheWorkflowRepository.Performthefollowing:
Logontotheowf_mgrschemainSQL*Plus.(Ensurethattheaccountisunlocked.)
AtSQLprompt,enterthefollowingcommand:
@
Substitute
Now,runwfnladd.sqlattheSQLprompt,asshownbelow:
@
2.
Toviewthegeneratedcodefortheprocessflow,double-clicktheOWB_DEMOjobintheControlCenterJobspanel.
InthePKdialogbox,clicktheScripttab(highlightedinthescreenshot).NotethatWarehouseBuildergeneratesthe.xmlscriptfortheprocessflow.
Toviewthegeneratedcode,selectPK.TheViewcodebuttonisenabled.
ClickViewCode.
Scrolldown
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OWB 试验 手册