2487 - 使用交互式性能助手实现 Cognos 分析报告的最佳性能.pdf

1、IBM TechXchange 2025 conference 2487 Achieve Cognos Analytic Report Peak Performance Using Interactive Performance AssistantGeorge XSTSM,ArchitectIBM Business AnalyticsGeorge XuIBM TechXchange|2025 IBM Corporation1AgendaAgenda1.1.Cognos Report Rendering ArchitectureCognos Report Rendering Architectu

2、re2.Interactive Performance Assistant(IPA)3.Configuration4.Report Performance when Editing5.Background Report Execution6.Forward ThinkingIBM TechXchange|2025 IBM Corporation3#IBMTechXchange3Cognos Report Cognos Report Rendering Rendering ArchitectureArchitectureIBM TechXchange|2025 IBM CorporationPr

3、oduce HTML/EXCEL/PDF/CSV etc.Data Organization and PresentationLayout Pixel Perfect&VisualizationQuery PlanningQuery Execution(JDBC,MDX,RESTAPI,etc.)Rendering LayerCognos DataSet ServiceDatabaseDatabaseDatabaseDatabaseReporting data sourceA high performing report requires to consider all three areas

4、 shown at left.Carefully designed user experience.Complexity vs performanceWell defined distribution of work,aka,presentation,data transformation,aggregation and cache.Convenience often leads to a performance penalty.Governance/Guard railsCognos has built-in capability to optimize query,cache to pro

5、duce high performance report however a well thought design can avoid future pain/challengesAgendaAgendaIBM TechXchange|2025 IBM Corporation1.Cognos Report Rendering Architecture2.2.InteractiveInteractive Performance Assistant(IPA)Performance Assistant(IPA)3.Configuration4.Report Performance when Edi

6、ting5.Background Report Execution6.Forward Thinking5In Product Performance In Product Performance Assistant(IPPA,IPA)Assistant(IPPA,IPA)Fine detail performance informationPerformance info are collected on demandAnalysis performance without leaving Cognos browserSupport both interactive and batch rep