1、Overview Enterprise 6.5March 2004Slide 2Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.PreparationTurn of phonePlace a note.Notepad&pen.Grab a cup of coffee and relax.Slide 3Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Cou
2、rse ObjectivesOverview of main features&functions Both FC,InfoView&WebIntelligenceIllustrate key concepts-DemonstrationsResources ILT Webinars Online BooksThis presentation is internal only The information contained in this presentation is confidential and is not to be shown to customersSlide 4Confi
3、dential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.TopicsBack End Improvements Unicode support Performance Optimization MIPS Phase II CachingNew Tools CScheck WDeploy Changes to Config Tool WebI 2.7 to WebI 6.x Report MigrationSlide 5Confidential and proprietary.Copyrigh
4、t 2004 Business Objects S.A.All rights reserved.TopicsFull Client Improvements Business Objects DesignerThin Client Improvements InfoviewSlide 6Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.TopicsAdministration Connection Server New commands Module changes BOMa
5、in keySupervisor over the Web Define users,groups and assign profilesAuditing&Impact Analysis New categoriesBackend Improvements Enterprise 6.5March 2004Slide 8Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.TopicsBack End Improvements Unicode support Performance
6、 Optimization MIPS Phase II CachingUnicode Support Enterprise 6.5March 2004Slide 10Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.UnicodeUnicode is an encoding standard covering many languages,alphabets,and scripts throughout the world.It provides a unique numbe
7、r for every character,no matter what the platform,program,or language.Dont forget How to use these numbers depends on the product or application development.(Please check our product limitations in detail.)Slide 11Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.U
8、nicode-SupportedServer O/S Supported Windows and Unix server in E65Client O/S Windows 2000,Windows XPOther client software Browser:IE 6.0 SP1(with JRE v1.4.2 or higher),Netscape 7.0.2(with JRE v1.4.1)Acrobat reader:5.0 or higher(with Asian font packs if user requires to display CJK)Unicode database
9、Oracle 9iR2 MS SQL 2000 Server SP3 DB2 UDB v8.1 NT/UNIXSlide 12Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Unicode Not SupportedReporter You can connect Unicode database but characters in a report are corrupted.OLAP products e.g.,OLAP Connect,MDX,WebI OLAPRep
10、ository No Unicode stringBi-directional language support(e.g.,Arabic)Font Open type fontNon-Unicode compliant operating system e.g.,Windows 98 Slide 13Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.UnicodeTo work with Unicode database,the following configuration
11、s should be appropriately set:Database middleware setting Connectivity file setting Physical font installed in both client and server machine Font files,used in WebI,setting Set Unicode flag ON for each Universe in Designer(Oracle,SQLServer)Slide 14Confidential and proprietary.Copyright 2004 Busines
12、s Objects S.A.All rights reserved.UnicodeWebIntelligence only Create a WebIntelligence report against Unicode database Access&display a report contained Unicode data through WebIntelligenceMIPS Phase II Enterprise 6.5March 2004Slide 16Confidential and proprietary.Copyright 2004 Business Objects S.A.
13、All rights reserved.MIPS Phase IIMIPS is Multi-instance performance stack.MIPS project enables to gain Performance and Scalability by changing the Tosca architecture.Theses changes consists in:Grouping all the processing attached to a session on the same machine,Transferring most of the portal and W
14、eb Intelligence workflow from the WIQT to the API Broker in order minimize the use of mono-threaded WIQT process.Slide 17Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.MIPS Phase IIMIPS modifies Tosca architecture in order to build identical stacks that runs on
15、all the servers composed of:1 Dispatcher,1 API Broker 1 Session Manager 1 Login Server(optional)1 pool of WIQT 1 or several Cadenza server 1 BO Manager 1 pool of BusObj/BOL processesIn order to enable different connectivity on different machines,Connection Server is not part of MIPS.Slide 18Confiden
16、tial and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.MIPS Phase IIWithout MIPSWith MIPSClient 1App ServerApp ServerAPI BrokerCluster NodeSession MgrWIQTCdz SrvLogin SrvBO MgrBusObj/BOLWIQTCdz SrvBO MgrBusObj/BOLCluster ManagerAPI BrokerSession MgrWIQTCdz SrvLogin SrvBO MgrBus
17、Obj/BOLCluster NodeAPI BrokerSession MgrWIQTCdz SrvLogin SrvBO MgrBusObj/BOLClient 2Client 1Client 2Slide 19Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.MIPS Phase IIImprove scalability and fault tolerance Avoid the need to start a WIQT process for simple user
18、 workflows:Login,browse document lists,view.WID doc Secondary nodes become isolated and autonomous=consistent with our load balancing strategy(CLD/CSS)Improve performance Optimize communication paths Replace numerous costly inter-machine Corba calls(over network)by intra-machine calls(in memory)Coul
19、d then decide to merge some components in the same process,for example APIBroker&Session Manager Transmit big files via descriptors instead of Corba streamsSlide 20Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.MIPS Phase IIReport EnginesRepositoryConnection Ser
20、verOLAP O.M.Cluster ManagerASF ManagerLogin ServerAudit ServerStorage Mgr revisited WIQT Repo Access DX&UX for legacy onlyCDZ New WebIReport Engine ServerWIQT RELegacy BusObj/BOLWebi OLAP EngineBO MgrWIQT portal tunelling onlyAPI Broker(Portal Server)ADE Serverfor ActiveX User Admin ServerUser Admin
21、 SDK BeanSDK RE Bean/COMSDK WI Bean/COMPortal pages asp/jspCDZ Servlet/ISAPIHSAL/JHSALAdmin Servlet/ISAPIAdmin ConsoleCDZ AppletDHTML ClientActiveX ViewerWebi OLAPBCA SchedulerC/S AppsReporter,Designer,Supervisor,BCA ConsoleStorageApplication ServicesProcessingMiddle TierPresentationWeb TierAudit DB
22、InfoviewPortal workflowsClient DatabasesShared StorageDispatcherReport EnginesPortalBackboneConnectivity ASF UX DXInfoview and WebI onlyh multi-threaded componentsLegacy reportsSessionZabo Servlet/ISAPIZaboWebi Document Caching Enterprise 6.5March 2004Slide 22Confidential and proprietary.Copyright 2
23、004 Business Objects S.A.All rights reserved.WebIntelligence Document CachingCaching:one of range of performance improvementsBetter viewing performance in InfoView of published webi docs(in HTML,PDF and Excel)Two caching methods:Can pre-load cache with BCA(corporate docs only)Real-time caching drive
24、n by user interactions(1st user pays)Applies to both Draft mode and Page-by-pageAdministration Console parameters:Activate viewing cache(minimum for using BCA preload)Activate real-time caching(additional step for activating cache on viewing)Works also in Interactive Viewing and DrillNew Tools Enter
25、prise 6.5March 2004Slide 24Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.TopicsNew Tools CScheck Changes to Config Tool WDeploy WebI 2.7 to WebI 6.x Report MigrationCSCHECK Enterprise 6.5March 2004Configuration Tool Enterprise 6.5March 2004Slide 27Confidential
26、and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Apache/Tomcat Installer on BOBJ CD Apache Tomcat installer now on BOBJ CD Make Apache/Tomcat install and configuration so much easier Versions:Apache 1.3.27-Tomcat 4.1.29 JDK 1.3.1 Installer also configures Apache/Tomcat connect
27、or No manual file config,default port number is 8085Slide 28Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Configuration Tool Enhancements in 6.1b Much simplified wizard Less steps,more settings done by default For IIS/IIS(ASP)and Apache/Tomcat(JSP)only Use the
28、new wdeploy tool for all other configs Better error checking Including users security profile for setting up node as a serviceWDeploy Tool Enterprise 6.5March 2004Slide 30Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.WDeploy Tool A tool for configuring J2EE app
29、lication servers Command line tool,using a series of parameters WebLogic,WebSphere,SunOne(see PAR)Available for Windows and UNIX configurations What problem it addresses The perception that the Config Tool behaves as a black box Add new app server platforms support easily What it allows you to do Cr
30、eate WAR files that include cluster-and ORB-specific info Include in the WAR file information for a specific app server Add static resources to the WAR file Deploy and remove a web applicationSlide 31Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Config Tool vs.
31、WDeployApplication serverORB Deployment Tool IIS Config ToolConfig ToolTomcat+ApacheConfig ToolConfig ToolWebLogicConfig ToolwdeployWebSphereConfig ToolwdeploySunONEConfig ToolwdeployOthersConfig ToolwdeployYou must use config tool to configure the ORBFor app server deployment,see table belowReport
32、Migration Tool Enterprise 6.5March 2004Slide 33Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Report MigrationGoal:automatically migrate reports WebI 2.x to WebI 6.5 documents BusinessObjects 5 and 6 to WebI 6.5 documentsE6.0 and E6.1 On-the-fly migration(WebI 2
33、.x to WebI 6 only)Introducing in E6.5 One migration tool for FC to WebI and WebI to WebI Interactive migration and batch migrationAvailability consulting FC to WebI report migration available to field personnel only Strongly recommend that FC report migration be consultant controlled,this is a trick
34、y exerciseSlide 34Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Report Migration ToolDeployment Java application based on the WebIntelligence SDK Supports both ASP and JSP servers,Windows and UNIX Runs on the WebIntelligence server,cannot be activated remotely
35、All reports to migrate must be stored in the BOBJ repositoryRepositoryWebIntelligenceServerMigration toolSlide 35Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Report Migration TimingWebI 2.x to WebI 6FC to WebI 6E6.0 and E6.1 On the flyE6.5 On the fly Interacti
36、ve Batch Interactive BatchChoosing migration type in E6.5Slide 36Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.The goal is to migrate as many FC reports as possible Some reports will be fully migrated Some reports will be partially migrated,with some degradatio
37、n Some reports wont be migrated at allAnything that is not fully migrated is logged Log database contains detailed info about degradation Log analysis will help consultants/customers understand what happened and produce workarounds A universe is available so users can build reports on the log databa
38、seMigration StrategySlide 37Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Feature by Feature MigrationDocument AreaFeatures not migratedMigrated FeaturesData Providers OLAP DP Free Hand SQL DP Stored Procedures DP Personal Files DP VBA DP Universe DPQuery Multi
39、 DP Synchronized Combined Queries(U,-)Object Comparison Complex and correlated subqueries User Defined Object Edit SQL Single DP Multi DP not synchronized Scope of analysisVariables Some Functions(Runningxxx,Previous,.)WHERE keyword All functions available in WebI 6 Grouped VariablesReport Structure
40、 Custom sorts Value-Based Breaks Rank Conditional Block/Section Formatting Ole objects and Pictures Tables,Crosstabs,Free cells Sections Breaks Filters AlertersCharts Some formatting Series/Groups All chart Types Charts DataReport Formatting Fill Patterns and colors,some border types Most formatting
41、Drill Drill migratesSlide 38Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Fully migrated documents Documents with multiple reports,sections,multiple blocks,simple variables,multiple universe DPs not synchronizedPartially migrated documents Reports with multi DP
42、 synchronized Reports with advanced variablesNon-migrated documents Reports with non-universe DPs Reports with advanced query featuresWhat Documents MigrateSlide 39Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Log AnalysisLog Analysis Pressing Analyze button du
43、mps log.xml file in RDBMS(and connection is created if needed)A WebIntelligence session is launched with predefined universe and reportsUsers can view existing log reports or create new onesPredefined reportsFor each FC document,show migration issues,severity,cause,result,possible workaroundsFor all
44、 documents,show most used features which do not migrate,by document area(DPs,Query,Variables,Structure)Business Objects Enterprise 6.5March 2004Slide 41Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.TopicsFull Client Improvements Business Objects Designer Index
45、AwarenessThin Client Improvements Infoview WebIntelligenceFull Client Features Enterprise 6.5March 2004Slide 43Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Horizontal Bar Charts in BusObj 6.5Goal Match chart type available in WebIntelligence Address frequent c
46、ustomer enhancement requestSame feature as vertical bar charts,just horizontal!Slide 44Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Designer-Derived TablesMove more processing server side Do more computations where the data is Use DB server processing powerBet
47、ter query expressiveness Enable nested SQL statement in FROM clause per ANSI-92 standard Define logical datasets and reuse them in FROM clause of other queries Allow users to define objects based on these derived tablesSlide 45Confidential and proprietary.Copyright 2004 Business Objects S.A.All righ
48、ts reserved.Index AwarenessGoal:improve query performance by reducing the number of tables and joinsHow it works:Define for an object a list of primary keys and foreign keys Primary key definition reduces joins in filters Foreign key definition reduces number of tables and joinsSlide 46Confidential
49、and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.Index DefinitionSlide 47Confidential and proprietary.Copyright 2004 Business Objects S.A.All rights reserved.ANSI 92 SQLFull outer join syntaxCondition either in WHERE or FROM clauseExample 1:Condition in WHERE select name,custo
50、mer.cust_id,orders.cust_id,orders.dtfrom(CUSTOMER LEFT OUTER JOIN ORDERS ON(CUSTOMER.CUST_ID=ORDERS.CUST_ID)where orders.dt09/01/02Example 2:Condition in FROM select name,customer.cust_id,orders.cust_id,orders.dtfrom(CUSTOMER LEFT OUTER JOIN ORDERS ON(CUSTOMER.CUST_ID=ORDERS.CUST_ID AND orders.dt09/
