Siebel BIEE Overview精髓XXXX0808

InsertPictureHereOracleBIEE(OBIEE)OverviewJanbaoChang2011-8-82WebServer(IIS,Tomcat,Websphere,iPlanet)OracleBIServerIntelligentRequestGenerationExternalizedAuthenticationOracleBIEEArchitectureDataSourceAdaptersNavigatorLogicalRequestGenerationAggregateNavigatorFragmentationOptimizationMulti-Pass/Sub-RequestLogicOptimizedQueryRewritesSessionManagementMetadataInterchangeLogicalSQLODBC/JDBC(LogicalBusinessModel)CacheServicesLDAPDBAuthenticationCustomAuthenticatorOracleBIAdministrationAnalyticalandOperationalDataSourcesMetadataDocumentationServicesMetadataManagementServicesMulti-UserDevelopmentServicesServerManagementServicesODBCoverTCP/IP(SSL)System/PerfMonitoringOracleBIClusterControllerODBC,CLI,OCI,XML,MDXOracleBIWebSOAPWebServices,XMLandURLInterfaceCacheServices(Web)&ConnectionMngmtXMLFrameworkWebCatalogServiceUserProfiling,SecurityandSessionMngmtOracleInteractiveDashboardsOracleAnswersLoadBalancerSecurityServicesQueryGovern.OracleDeliversServerScheduling/EventServicesAgentExecutionLogicDeviceAdaptiveContentTCP/IP(SSL)JavascriptforUsability&InteractivityWebBrowserXML,HTML,XLS,PDF,TXToverHTTP/HTTPSExternalApplicationsandPortalsHTML,SOAPoverHTTP/HTTPSExecutionEngineSAWBridge(J2EE/ISAPI)TCP/IP(SSL)3商务智能基础架构•主要Server组件为：–OracleBIServer–OraclePresentationServer•处理机制–OraclePresentationServer接受数据查询请求并将OracleBIServer返回的数据查询结果以仪表盘、报表等形式展现。–OracleBIServer处理OraclePresentationServer转发过来的数据查询请求，并从数据仓库中获取数据。•主要客户端组件为：–逻辑模型开发工具－Administration–展现层管理工具－CatalogManger•BI应用主要组件包括：–DataWarehouseApplicationConsole(DAC)–OEMInformaticaPowerCenter•BI应用预先构建包包括：–数据仓库模型；–Inforatica资料库(Repository)–mappings,workflows–DAC资料库(Repository)–任务(workflows)以及依赖关系，执行计划等。–逻辑模型资料库(Repository)－物理数据源、逻辑模型和主题域–仪表盘和报表4EnterpriseBusinessModelAdministration企业业务模型管理PhysicalLayer–“IntelligentRequestGeneration”物理层ReadsinsystemcatalogMultiplesourcesOptimizedSQLgenerationRegardlessofSchemaFunctionshiptoappropriatedatasources/CompensationDB2SupplyChainDMTeradataOLAPOracleERP.XMLDataSourceSQLServerAcxiomSiebelOperational5BusinessModelLayer–“CalculationEngine”业务模型层PhysicalcomplexityconvertedtologicalsubjectareasDrill-PathsComplex/DerivedMeasures(Level-based,timeseries,dimension-specific,nested)Aggregate/FragmentAwareEnterpriseBusinessModelAdministration企业业务模型管理6PresentationLayer表示层Role-based,incontext,personalizedpresentation–OracleAnswersEnterpriseBusinessModelAdministration企业业务模型管理7InsertPictureHereSiebelAnalyticsArchitectureJanbaoChang2011-8-89SiebelAnalyticsArchitecture•Ismadeupoffivemaincomponents–Clients–SiebelAnalyticsWebServer–SiebelAnalyticsServer–SiebelAnalyticsScheduler–DataSourcesClientsSiebelAnalyticsWebServerSiebelAnalyticsServerSiebelAnalyticsSchedulerDataSourcesAccessanalyticsinformationviaWebBrowser•SiebelAnswers问答•SiebelDashboards仪表盘•SiebelDelivers发布提供--客户端消费的可视化信息--的过程接收分析服务器的数据并提供给客户端.webcat（catalog文件）•用户通过管理界面定义的应用的dashboard，通过BIAnwsers定义出来的各种报表，以及这些仪表盘，报表和用户或者组的权限对应关系管理和执行请求数据分析的任务调度在指定的时间里送给用户报告提供高效的处理--智能访问的物理数据源和结构化信息•Relationaldatabases关系型数据库•OLAPdatabasesOLAP数据库•Flatfiles平面文件•Spreadsheets电子数据表10•SeveralimportantcomponentsareusedbytheSiebelAnalyticsServer(一些重要的组件)–Repositoryfile(.rpd)包含代表分析模型的元数据，–Cache包含的查询结果–NQSConfig.ini配置文件，说明控制过程的值–DBFeatures.ini配置文件，说明控制SQL生成的值–Logfiles日志文件SiebelAnalyticsServerDetailsSiebelAnalyticsServerCacheNQSConfig.iniDBFeatures.iniNQServer.logNQQuery.log.rpdSiebelAnalyticsAdministrationTool分成三个层次：•Physical–representsthedatasources表示数据源•Business–modelsthedatasourceintofactsanddimensions将数据源建模成事实维和维度•Presentation–specifiestheusersviewofthemodel指定的用户模型视图;rendered（呈现）inSiebelAnswers1112SampleRequestProcessing•UserviewsadashboardorsubmitsanAnswersrequest–用户查看一仪表盘或提交一个问答请求•TheSiebelAnalyticsWebServermakesarequesttotheSiebelAnalyticsServertoretrievetherequesteddata–SiebelAnalyticsWebServer生成一请求给SiebelAnalyticsServer检索所请求的数据•TheSiebelAnalyticsServerusingthe.rpdfile,optimizesfunctionstorequestthedatafromthedatasources–SiebelAnalyticsServer使用.RPD文件，优化功能，从数据源请求数据•TheSiebelAnalyticsServerreceivesthedatafromthedatasourcesandprocessasnecessary–SiebelAnalyticsServer从数据源接收数据，必要的处理过程•TheSiebelAnalyticsServerpassesthedatatotheSiebelAnalyticsWebServer–SiebelAnalyticsServer传递数据给SiebelAnalyticsWebServer•TheSiebelAnalyticsWebServerformatsthedataandsendsittotheclient–SiebelAnalyticsWebServer格式化数据并送给ClientClientsSiebelAnalyticsWebServerSiebelAnalyticsServerDataSources12345613WhatdoesBIEEdo?14Dashbords15Answers16AdministratorTools