企業(yè)概要培訓(xùn)Overview

Enterprise6.5March2004PreparationTurnofphone…Placeanote..Notepad&pen..Grabacupofcoffeeandrelax..CourseObjectivesOverviewofmainfeatures&functionsBothFC,InfoView&WebIntelligenceIllustratekeyconcepts-DemonstrationsResourcesILTWebinarsOnlineBooksThispresentationisinternalonlyTheinformationcontainedinthispresentationisconfidentialandisnottobeshowntocustomersTopicsBackEndImprovementsUnicodesupportPerformanceOptimization–MIPSPhaseIICachingNewToolsCScheckWDeployChangestoConfigToolWebI2.7toWebI6.xReportMigrationTopicsFullClientImprovementsBusinessObjectsDesignerThinClientImprovementsInfoviewTopicsAdministrationConnectionServerNewcommandsModulechangesBOMainkeySupervisorovertheWebDefineusers,groupsandassignprofilesAuditing&ImpactAnalysisNewcategoriesBackendImprovements

Enterprise6.5March2004TopicsBackEndImprovementsUnicodesupportPerformanceOptimization–MIPSPhaseIICachingUnicodeSupport

Enterprise6.5March2004UnicodeUnicodeisanencodingstandardcoveringmanylanguages,alphabets,andscriptsthroughouttheworld.

Itprovidesauniquenumberforeverycharacter,nomatterwhattheplatform,program,orlanguage.Don’tforgetHowtousethesenumbersdependsontheproductorapplicationdevelopment.(Pleasecheckourproductlimitationsindetail.)Unicode-SupportedServerO/SSupportedWindowsandUnixserverinE65ClientO/SWindows2000,WindowsXPOtherclientsoftwareBrowser:

IE

6.0SP1(withJREv1.4.2orhigher), Netscape

7.0.2(withJREv1.4.1)Acrobatreader:5.0orhigher(withAsianfontpacksifuserrequirestodisplayCJK)UnicodedatabaseOracle9iR2MSSQL2000ServerSP3DB2UDBv8.1NT/UNIXUnicode–NotSupportedReporterYoucanconnectUnicodedatabasebutcharactersinareportarecorrupted.OLAPproductse.g.,OLAPConnect,MDX,WebIOLAPRepositoryNoUnicodestringBi-directionallanguagesupport(e.g.,Arabic)FontOpentypefontNon-Unicodecompliantoperatingsysteme.g.,Windows98UnicodeToworkwithUnicodedatabase,thefollowingconfigurationsshouldbeappropriatelyset:DatabasemiddlewaresettingConnectivityfilesettingPhysicalfontinstalledinbothclientandservermachineFontfiles,usedinWebI,settingSetUnicodeflagONforeachUniverseinDesigner(Oracle,SQLServer)UnicodeWebIntelligenceonlyCreateaWebIntelligencereportagainstUnicodedatabaseAccess&displayareportcontainedUnicodedatathroughWebIntelligenceMIPS–PhaseII

Enterprise6.5March2004MIPS–PhaseIIMIPSisMulti-instanceperformancestack.MIPSprojectenablestogainPerformanceandScalabilitybychangingtheToscaarchitecture.Theseschangesconsistsin:Groupingalltheprocessingattachedtoasessiononthesamemachine,TransferringmostoftheportalandWebIntelligenceworkflowfromtheWIQTtotheAPIBrokerinorderminimizetheuseofmono-threadedWIQTprocess.MIPS–PhaseIIMIPSmodifiesToscaarchitectureinordertobuildidenticalstacksthatrunsonalltheserverscomposedof:1Dispatcher,1APIBroker1SessionManager1LoginServer(optional)1poolofWIQT1orseveralCadenzaserver1BOManager1poolofBusObj/BOLprocessesInordertoenabledifferentconnectivityondifferentmachines,ConnectionServerisnotpartofMIPS.MIPS–PhaseIIWithoutMIPSWithMIPSClient1AppServerAppServerAPIBrokerClusterNodeSessionMgrWIQTCdzSrvLoginSrvBOMgrBusObj/BOLWIQTCdzSrvBOMgrBusObj/BOLClusterManagerAPIBrokerSessionMgrWIQTCdzSrvLoginSrvBOMgrBusObj/BOLClusterNodeAPIBrokerSessionMgrWIQTCdzSrvLoginSrvBOMgrBusObj/BOLClient2Client1Client2MIPS–PhaseIIImprovescalabilityandfaulttoleranceAvoidtheneedtostartaWIQTprocessforsimpleuserworkflows:Login,browsedocumentlists,view.WIDdocSecondarynodesbecomeisolatedandautonomous=>consistentwithourloadbalancingstrategy(CLD/CSS)ImproveperformanceOptimizecommunicationpathsReplacenumerouscostlyinter-machineCorbacalls(overnetwork)byintra-machinecalls(inmemory)Couldthendecidetomergesomecomponentsinthesameprocess,forexleAPIBroker&SessionManagerTransmitbigfilesviadescriptorsinsteadofCorbastreamsMIPS–PhaseIIReportEnginesRepositoryConnectionServerOLAPO.M.ClusterManagerASFManagerLoginServerAuditServerStorageMgrrevisitedWIQTRepoAccess

DX&UXforlegacyonlyCDZNewWebI

ReportEngineServerWIQTRE

LegacyBusObj/BOL

WebiOLAPEngineBOMgrWIQTportal

tunellingonlyAPIBroker(PortalServer)ADEServer

forActiveXUserAdminServerUserAdminSDKBeanSDKREBean/COMSDKWIBean/COMPortalpagesasp/jspCDZServlet/ISAPIHSAL/JHSALAdminServlet/ISAPIAdminConsoleCDZAppletDHTMLClientActiveXViewerWebiOLAPBCASchedulerC/SAppsReporter,Designer,Supervisor,BCAConsoleStorageApplicationServicesProcessingMiddleTierPresentationWebTierAuditDBInfoviewPortal

workflowsClientDatabasesSharedStorageDispatcherReportEnginesPortalBackboneConnectivityASFUXDXInfoviewandWebIonlyhmulti-threadedcomponentsLegacyreportsSessionZaboServlet/ISAPIZaboWebiDocumentCaching

Enterprise6.5March2004WebIntelligenceDocumentCachingCaching:oneofrangeofperformanceimprovementsBetterviewingperformanceinInfoViewofpublishedwebidocs(inHTML,PDFandExcel)Twocachingmethods:Canpre-loadcachewithBCA(corporatedocsonly)Real-timecachingdrivenbyuserinteractions(1stuserpays)AppliestobothDraftmodeandbyAdministrationConsoleparameters:Activateviewingcache(minimumforusingBCApreload)Activatereal-timecaching(additionalstepforactivatingcacheonviewing)WorksalsoinInteractiveViewingandDrillNewTools

Enterprise6.5March2004TopicsNewToolsCScheckChangestoConfigToolWDeployWebI2.7toWebI6.xReportMigrationCSCHECK

Enterprise6.5March2004ConfigurationTool

Enterprise6.5March2004Apache/TomcatInstalleronBOBJCDApacheTomcatinstallernowonBOBJCDMakeApache/TomcatinstallandconfigurationsomucheasierInstalleralsoconfiguresApache/TomcatconnectorNomanualfileconfig,defaultportnumberis8085ConfigurationToolEnhancementsin6.1bMuchsimplifiedwizardLesssteps,moresettingsdonebydefaultForIIS/IIS(ASP)andApache/Tomcat(JSP)onlyUsethenewwdeploytoolforallotherconfigsBettererrorcheckingIncludinguser’ssecurityprofileforsettingupnodeasaserviceWDeployTool

Enterprise6.5March2004WDeployToolAtoolforconfiguringJ2EEapplicationserversCommandlinetool,usingaseriesofparametersWebLogic,WebSphere,SunOne(seePAR)AvailableforWindowsandUNIXconfigurationsWhatproblemitaddressesTheperceptionthattheConfigToolbehavesasa?

blackbox

?AddnewappserverplatformssupporteasilyWhatitallowsyoutodoCreateWARfilesthatincludecluster-andORB-specificinfoIncludeintheWARfileinformationforaspecificappserverAddstaticresourcestotheWARfileDeployandremoveawebapplicationConfigToolvs.WDeployApplicationserverORBDeploymentToolIISConfigToolConfigToolTomcat+ApacheConfigToolConfigToolWebLogicConfigToolwdeployWebSphereConfigToolwdeploySunONEConfigToolwdeployOthersConfigToolwdeployYoumustuseconfigtooltoconfiguretheORBForappserverdeployment,seetablebelowReportMigrationTool

Enterprise6.5March2004ReportMigrationGoal:automaticallymigratereportsWebI2.xtoWebI6.5documentsBusinessObjects5and6toWebI6.5documentsE6.0andE6.1On-the-flymigration(WebI2.xtoWebI6only)IntroducinginE6.5OnemigrationtoolforFCtoWebIandWebItoWebIInteractivemigrationandbatchmigrationAvailability–consultingFCtoWebIreportmigrationavailabletofieldpersonnelonlyStronglyrecommendthatFCreportmigrationbeconsultantcontrolled,thisisatrickyexerciseReportMigrationToolDeploymentJavaapplicationbasedontheWebIntelligenceSDKSupportsbothASPandJSPservers,WindowsandUNIXRunsontheWebIntelligenceserver,cannotbeactivatedremotelyAllreportstomigratemustbestoredintheBOBJrepositoryRepositoryWebIntelligenceServerMigrationtoolReportMigrationTimingWebI2.xtoWebI6FCtoWebI6E6.0andE6.1OntheflyE6.5OntheflyInteractiveBatchInteractiveBatchChoosingmigrationtypeinE6.5ThegoalistomigrateasmanyFCreportsaspossibleSomereportswillbefullymigratedSomereportswillbepartiallymigrated,withsomedegradationSomereportswon’tbemigratedatallAnythingthatisnotfullymigratedisloggedLogdatabasecontainsdetailedinfoaboutdegradationLoganalysiswillhelpconsultants/customersunderstandwhathappenedandproduceworkaroundsAuniverseisavailablesouserscanbuildreportsonthelogdatabaseMigrationStrategyFeaturebyFeatureMigrationDocumentAreaFeaturesnotmigratedMigratedFeaturesDataProvidersOLAPDPFreeHandSQLDPStoredProceduresDPPersonalFilesDPVBADPUniverseDPQueryMultiDPSynchronizedCombinedQueries(U,∩,-)ObjectComparisonComplexandcorrelatedsubqueriesUserDefinedObjectEditSQLSingleDPMultiDPnotsynchronizedScopeofanalysisVariablesSomeFunctions(Runningxxx,Previous,..)WHEREkeywordAllfunctionsavailableinWebI6GroupedVariablesReportStructureCustomsortsValue-BasedBreaksRankConditionalBlock/SectionFormattingOleobjectsandPicturesTables,Crosstabs,FreecellsSectionsBreaksFiltersAlertersChartsSomeformattingSeries/GroupsAllchartTypesChartsDataReportFormattingFillPatternsandcolors,somebordertypesMostformattingDrillDrillmigratesFullymigrateddocumentsDocumentswithmultiplereports,sections,multipleblocks,simplevariables,multipleuniverseDPsnotsynchronizedPartiallymigrateddocumentsReportswithmultiDPsynchronizedReportswithadvancedvariablesNon-migrateddocumentsReportswithnon-universeDPsReportswithadvancedqueryfeaturesWhatDocumentsMigrateLogAnalysisLogAnalysisPressing?

Analyze

?buttondumpslog.xmlfileinRDBMS(andconnectioniscreatedifneeded)AWebIntelligencesessionislaunchedwithpredefineduniverseandreportsUserscanviewexistinglogreportsorcreatenewonesPredefinedreportsForeachFCdocument,showmigrationissues,severity,cause,result,possibleworkaroundsForalldocuments,showmostusedfeatureswhichdonotmigrate,bydocumentarea(DPs,Query,Variables,Structure)BusinessObjects

Enterprise6.5March2004TopicsFullClientImprovementsBusinessObjectsDesignerIndexAwarenessThinClientImprovementsInfoviewWebIntelligenceFullClientFeatures

Enterprise6.5March2004HorizontalBarChartsinBusObj6.5GoalMatchcharttypeavailableinWebIntelligenceAddressfrequentcustomerenhancementrequestSamefeatureasverticalbarcharts,justhorizontal!Designer-DerivedTablesMovemoreprocessingserversideDomorecomputationswherethedataisUseDBserverprocessingpowerBetterqueryexpressivenessEnablenestedSQLstatementinFROMclauseperANSI-92standardDefinelogicaldatasetsandreusetheminFROMclauseofotherqueriesAllowuserstodefineobjectsbasedonthesederivedtablesIndexAwarenessGoal:improvequeryperformancebyreducingthenumberoftablesandjoinsHowitworks:DefineforanobjectalistofprimarykeysandforeignkeysPrimarykeydefinitionreducesjoinsinfiltersForeignkeydefinitionreducesnumberoftablesandjoinsIndexDefinitionANSI92SQLFullouterjoinsyntaxConditioneitherin?

WHERE

?or?

FROM

?clauseExle1:Conditionin?

WHERE

?selectname,customer.cust_id,orders.cust_id,orders.dtfrom(CUSTOMERLEFTOUTERJOINORDERSON(CUSTOMER.CUST_ID=ORDERS.CUST_ID))whereorders.dt>'09/01/02‘Exle2:Conditionin?

FROM

?selectname,customer.cust_id,orders.cust_id,orders.dtfrom(CUSTOMERLEFTOUTERJOINORDERSON(CUSTOMER.CUST_ID=ORDERS.CUST_IDANDorders.dt>'09/01/02'))NewSemanticLayerFeaturesinE6.5DynamicgenerationofderivedtablesFCandWebIBasedontableweightsComplexuser-definedobjectsFree-formSQL(nomorerestrictions)FConlyThinClientFeatures

Enterprise6.5March2004TopicsThinClientImprovementsInfoviewInfoViewFeatures

Enterprise6.5March2004TopicsInfoViewFeaturesMultiDPnon-syncAlertersInteractiveViewing508SupportEnhancedViewingMulti–DP(non-sync)

Enterprise6.5March2004Addingmultipleuniversedataproviderstothesamedocument(JavaReportPanelonly)SameDocument(newreport)SameReport(separateblock)JustaddtheresultsobjectsforlaterNOTsynchronized.YoucannotmergeobjectsfromonequeryintoanotherqueryUsecases:Createa“minidashboard”ofdatafromdifferentsourcesCustomerswithsameuniversesatdifferentslicesoftimeManagingfewerdocuments:Separatedocsmergedinto“one”documentwithasetofreportsImprovenavigation(relatedblocksinsamereports)MultipleDataProviders(nonsynchronized)MultipleDP:UncontrolledActionsDrag&DropvariableswithobjectsfromotherDPsUsingFormulaEditorNote:

#ContextforMeasuresand

#IncompatibleforDimensions/DetailsMultipleDP:CreateaSectionSectionswillwork,butcontentfromotherDPwillrepeatCreatingSectionsonmixedDPreportsReportFiltersAppliedtoonlyappropriateblocksFilteronYearforMultiDP1willnotaffectMultiDP2NodifferencewithAND/OR,onlyobjectsrelatedtoqueryareaffectedMultipleDP:ReportFilters&DrillDrillFiltersSameaffectinDrillasReportFiltersAppliedtoonlyappropriateblocksInInfoViewsameasinApplet(onlyonappropriateBlocks)Alerters

Enterprise6.5March2004AlertersPhase1:OverviewNewAlerterButtoninJavaReportPanelConditionalStylingbasedon:CellContentsObjectValueFormulasStylingtoshow:Contentdisplay:Text/Formula,Readcontentas,Format#Text:Font,Color,AlignmentBackground:Color,Image/Skin,DisplayBorder:Color&SizeFullClientisbaseforfunctionalityanduserinterfaceSomeimprovementstoFullClientfunctionalityAlerters:ManagingAlertersManageAlertersCreateEditDeleteActivateorDeactivateDuplicateRemoveChangepriority(notdisplayedinscreenshot)ClickingonAlerterbuttoninJavaReportPanelAlerters:BuildingComplexAlertersCanbequitepowerfulDefinemanylevelsofSubalerters&ConditionsMultipleconditions:“Ifrevenue<50,000(condition1)andthesalesperson=“Joe”(condition2),thenmakethetext“Joe’sintrouble”AddingSubalerters(totheabove):“Ifrevenue>=50,000andthesalesperson=“Joe”,thenmakethetext“Joe’sdoingOK”TestingLimits(youcanpushbeyondifdesired):Max=30alerterscreatedinadocument,20columns/rowshaving10alertersactiveinoneormoretables.InteractiveViewing

Enterprise6.5March2004InteractiveViewing:OverviewPublishedWebIntelligenceDocumentsviewedinInfoViewe6.1includedAdd/Replace/RemoveobjectsFilterby&Sort(charts&tables)SimpleCalculationse6.5willadd:SetasSectionPivotAxesTurnto…FormatCellInteractiveViewing:PivotAxes&TurntoPivotaxesswitchesaxesinacross-taborX&Zaxesfor3DchartsTurnto…DisplayslistofblocktemplatesonleftsideofInfoViewwindowContextSensitive:Onlyappropriatechart/tabletypesareavailableasoptions(othersgrayed)InteractiveViewingSetasSection:Asyoumightexpect(Objectbecomessection),right-clickSpacingofsectioncellisdefault-setNewparameterinconfig.jsfileFormatcell…DisplaysContextSensitive:Onlyappropriatechart/tabletypesareavailableasoptions(othersgrayed)508Support

Enterprise6.5March2004508Support:InfoViewandHTMLRPFederalAccountsrequire508SupportEnablenavigationwithoutmouse&screenreadersBasically,specialHTMLtagsanduseofframesWhyshouldyoucare?Everyonebenefitsfromeasierkeyboardnavigation,tabcontrolsEnhancedViewing

Enterprise6.5March2004EnhancedViewinge6.1reportviewingproblems:PagebypagecutsoffcontentversusDraftmodeperformancechallengeMargins“waste”spaceforreportviewing6.5Fix:XMLServersettingsXMLMediafileonserver,Enhanced_viewing_profiles.xmlLocatedHere

<installdir>\bin\config\bobjserver\enhanced_viewing_profiles.xmlNote:Youcanchangethepathwiththisregistry: HKEY_LOCAL_MACHINE\SOFTWARE\BusinessObjects\Suite6.0\default\WebIntelligence\EnhancedViewingProfilesFileEnhancedViewingNewdocumentpropertyforreportcreators(Applet)EnhancedViewingCheckedbydefaultforALLnewandforconvertedSambadocsSettingsappliedonlyinInfoView(i.e.notdocsviewedinApplet)WebIDocumentparameters<ENHANCED_MEDIAS_LIST><!--ForHTMLpagebypage(throughSDK)--><MEDIANAME="EnhancedPaginatedXML"OUTPUT="xml.ro"MODE="paginated"><PROPERTYNAME="output.dpi">96</PROPERTY> <PROPERTYNAME="page.format.orientation">portrait</PROPERTY><PROPERTYNAME="page.format.dimension.height">141732</PROPERTY> <PROPERTYNAME="page.format.dimension.width">141732</PROPERTY> <PROPERTYNAME="page.format.margin.top">0</PROPERTY> <PROPERTYNAME="page.format.margin.bottom">0</PROPERTY> <PROPERTYNAME="page.format.margin.left">0</PROPERTY> <PROPERTYNAME="page.format.margin.right">0</PROPERTY></MEDIA><!--ForHTMLDraftmode(throughSDK)--><MEDIANAME="EnhancedDraftXML"OUTPUT="xml.ro"MODE="normal"> <PROPERTYNAME="output.dpi">96</PROPERTY> <PROPERTYNAME="page.format.margin.top">0</PROPERTY> <PROPERTYNAME="page.format.margin.bottom">0</PROPERTY> <PROPERTYNAME="page.format.margin.left">0</PROPERTY> <PROPERTYNAME="page.format.margin.right">0</PROPERTY></MEDIA><!--ForPDF(throughSDK)--><MEDIANAME="EnhancedPDF"OUTPUT="pdf"MODE="paginated"> <PROPERTYNAME="output.dpi">96</PROPERTY></MEDIA>

<!--ForExcel(throughSDK)--><MEDIANAME="EnhancedExcel"OUTPUT="xls"MODE="normal"> <PROPERTYNAME="output.dpi">96</PROPERTY></MEDIA></ENHANCED_MEDIAS_LIST>The