biee-混合cube做法--多维数据源和关系数据源集成.doc

《biee-混合cube做法--多维数据源和关系数据源集成.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、FederatingEssbaseandRelationalDataSourcesinOracleBusinessIntelligenceSuiteEnterpriseEditionPlusPurposeInthistutorial,youlearnhowtofederateEssbasemultidimensionalsourceswithotherrelationaldatasourcessupportedinOracleBusinessIntelligence(OBI)SuiteEnterpriseEd

2、itionPlus.TimeApproximately1hourTopicsThistutorialcoversthefollowingtopics:OverviewPrerequisitesReferenceMaterialImportingDataSourcesintoanOracleBusinessIntelligenceRepositoryBuildingaBusinessModeltoDemonstrateHorizontalFederationBuildingaBusinessModeltoDem

3、onstrateVerticalFederationSummaryViewingScreenshotsPlacethecursoroverthisicontoloadandviewallthescreenshotsforthistutorial.(Caution:Thisactionloadsallscreenshotssimultaneously,soresponsetimemaybeslowdependingonyourInternetconnection.)Note:Alternatively,youc

4、anplacethecursoroveranindividualiconinthefollowingstepstoloadandviewonlythescreenshotassociatedwiththatstep.Youcanhideanindividualscreenshotbyclickingit.OverviewBeginningwithOracleBusinessIntelligenceSuiteEnterpriseEditionPlus10.1.3.3.2,Essbaseissupportedas

5、anOracleBusinessIntelligence(OBI)Serverdatasource.ThisprovidestheabilitytoexposeEssbasedatatoabroaduseraudienceviaOBIAnswers,OBIInteractiveDashboards,andOBIDelivers.UsingtheOBIServerrepository,developerscanbuildbusinessmodelsthatfederateEssbasedatasourceswi

6、thothersourcessupportedbyOBIServer.Thisincludeshorizontalfederation(whichprovidesreportsthatcandisplaydatafrombothEssbaseandrelationaldatasources)andverticalfederation(whichprovidesreportswiththeabilitytodrillthroughaggregateEssbasedataintodetailrelationald

7、ata).Thistutorialprovidesthefollowing:InstructionstoconnecttotheOBIAdministrationToolandcreateanewrepositoryStepstoimportEssbasecubesintothePhysicallayeroftherepositoryStepstoimportarelationaldatasourceintothePhysicallayeroftherepositoryStepstobuildabusines

8、smodelthatdemonstrateshorizontalfederationbetweenEssbaseandarelationalsourceStepstobuildabusinessmodelthatdemonstratesverticalfederationbetweenEssbaseandarelationalsourceStepstobuildthePresentationlaye