Cognos TM1 for Advanced Users - Presentation Transcript
ppt 2009年11月12日发布于美国，20页 内容结构如下：
1.Cognos TM1 for Advanced Users ® November 12th, 2009 Click to edit Master sub1tle style Sanjeev Datta Consultant for PerformanceG2 9/2/09
2.Connect with us Call us: 877.742.4276 Email Us: info@performanceg2.com Visit our Web site: performanceg2.com Watch our Cognos videos at: youtube.com/user/performanceg2 Click to edit Master sub1tle style Follow us: twitter.com/performanceg2 Read our blog: performanceg2.com/blog/ Upcoming Events: performanceg2.com/events/
3.IBM Cognos TM1 – Advanced Users November 12th, 2009 9/2/09
4.Session Objectives TM1 vs. Transformer TM1 Time Dimensions TM1 Cube Drill -Through Advanced Rules Data Spreading Techniques Executive Viewer Q&A 9/2/09
5.Table Manager (TM) 1 versus Transformer Online Analytical Processing (OLAP) Cubes Slice and Dice Top Down View Sort and Filter Rotate and Nest MDX 9/2/09
6.TM1 vs. Transformer TM1 Cubes Transformer PowerCubes On Demand Aggrega1on – Real Time Data Pre- ‐Aggregated Cubes, Longer Build Time Large Data Volumes – Vola1le Data Moderate Data Volumes Write Back Capabili1es – “What if” Analysis Offline Capabili1es–”Disconnected” Analysis Patented 64 bit in- ‐memory Architecture First/Last Query Same Speed Load/Merge Data using built- ‐in ETL tool from Merge Data from flat files, OLAP Dims ODBC/ODBO, SAP, Other Cubes etc. 9/2/09
7.Time Dimension TM1 treats Time Dimension as any other Dimension Single Time Dimension Multiple Time Dimension 9/2/09
8.Cube Drill Through Defines Detail Data associated with a cell in a cube Cube View, ODBC Data Source, TI Supported Data Sources 2 Components Drill Process Drill Assignment Rule 9/2/09
9.Demo 1 - Drill Through 9/2/09
10.Advanced Rules Cube specific calculations in TM1 Rules can be modified in any Text Editor Structure Area=Formula; [‘Sales Amount’]=[‘Qty Sold’]*[‘Unit Price’] Business Logic 9/2/09
11.Advanced Rules SKIPCHECK; Turns off Sparsity Algorithm FEEDERS; [Area]=>feeder statement; Identifies cells containing calculations 9/2/09
12.Demo 2 - Rules 9/2/09
13.Data Spreading in TM1 Relative Spreading Writes data back to the cubes Relative Spread Options Use other cubes data patterns as a basis Must share a common dimension between the source and target cells 9/2/09
14.Data Spreading Techniques in TM1 Data Spreading Techniques in TM1 Propor1onal Spread Equal Spread Repeat Method Percent Change Straight Line Method Growth Percentage Rela1ve Propor1onal Spread Rela1ve Percent Adjustment Repeat Leaves Equal Spread Leaves 9/2/09
15.Demo 3 – Data Spreading 9/2/09
16.Executive Viewer Perform Real-Time “What-If” and Ad-hoc Analysis Create professional, visually appealing reports for distribution View Information from different Perspectives Focus on Key Business Areas Enhance the Visual impact of Cube Views Customize Cube Views 9/2/09
17.Demo 4 – Executive Viewer 9/2/09
18.Q&A Session info@performanceg2.com 9/2/09
19.Connect with us Call us: 877.742.4276 Email Us: info@performanceg2.com Visit our Web site: performanceg2.com Watch our Cognos videos at: youtube.com/user/performanceg2 Follow us: twitter.com/performanceg2 Read our blog: performanceg2.com/blog/ Upcoming Events: performanceg2.com/events/
20.Thank your for attending our Webinar! info@performanceg2.com 9/2/09
1.Cognos TM1 for Advanced Users ® November 12th, 2009 Click to edit Master sub1tle style Sanjeev Datta Consultant for PerformanceG2 9/2/09
2.Connect with us Call us: 877.742.4276 Email Us: info@performanceg2.com Visit our Web site: performanceg2.com Watch our Cognos videos at: youtube.com/user/performanceg2 Click to edit Master sub1tle style Follow us: twitter.com/performanceg2 Read our blog: performanceg2.com/blog/ Upcoming Events: performanceg2.com/events/
3.IBM Cognos TM1 – Advanced Users November 12th, 2009 9/2/09
4.Session Objectives TM1 vs. Transformer TM1 Time Dimensions TM1 Cube Drill -Through Advanced Rules Data Spreading Techniques Executive Viewer Q&A 9/2/09
5.Table Manager (TM) 1 versus Transformer Online Analytical Processing (OLAP) Cubes Slice and Dice Top Down View Sort and Filter Rotate and Nest MDX 9/2/09
6.TM1 vs. Transformer TM1 Cubes Transformer PowerCubes On Demand Aggrega1on – Real Time Data Pre- ‐Aggregated Cubes, Longer Build Time Large Data Volumes – Vola1le Data Moderate Data Volumes Write Back Capabili1es – “What if” Analysis Offline Capabili1es–”Disconnected” Analysis Patented 64 bit in- ‐memory Architecture First/Last Query Same Speed Load/Merge Data using built- ‐in ETL tool from Merge Data from flat files, OLAP Dims ODBC/ODBO, SAP, Other Cubes etc. 9/2/09
7.Time Dimension TM1 treats Time Dimension as any other Dimension Single Time Dimension Multiple Time Dimension 9/2/09
8.Cube Drill Through Defines Detail Data associated with a cell in a cube Cube View, ODBC Data Source, TI Supported Data Sources 2 Components Drill Process Drill Assignment Rule 9/2/09
9.Demo 1 - Drill Through 9/2/09
10.Advanced Rules Cube specific calculations in TM1 Rules can be modified in any Text Editor Structure Area=Formula; [‘Sales Amount’]=[‘Qty Sold’]*[‘Unit Price’] Business Logic 9/2/09
11.Advanced Rules SKIPCHECK; Turns off Sparsity Algorithm FEEDERS; [Area]=>feeder statement; Identifies cells containing calculations 9/2/09
12.Demo 2 - Rules 9/2/09
13.Data Spreading in TM1 Relative Spreading Writes data back to the cubes Relative Spread Options Use other cubes data patterns as a basis Must share a common dimension between the source and target cells 9/2/09
14.Data Spreading Techniques in TM1 Data Spreading Techniques in TM1 Propor1onal Spread Equal Spread Repeat Method Percent Change Straight Line Method Growth Percentage Rela1ve Propor1onal Spread Rela1ve Percent Adjustment Repeat Leaves Equal Spread Leaves 9/2/09
15.Demo 3 – Data Spreading 9/2/09
16.Executive Viewer Perform Real-Time “What-If” and Ad-hoc Analysis Create professional, visually appealing reports for distribution View Information from different Perspectives Focus on Key Business Areas Enhance the Visual impact of Cube Views Customize Cube Views 9/2/09
17.Demo 4 – Executive Viewer 9/2/09
18.Q&A Session info@performanceg2.com 9/2/09
19.Connect with us Call us: 877.742.4276 Email Us: info@performanceg2.com Visit our Web site: performanceg2.com Watch our Cognos videos at: youtube.com/user/performanceg2 Follow us: twitter.com/performanceg2 Read our blog: performanceg2.com/blog/ Upcoming Events: performanceg2.com/events/
20.Thank your for attending our Webinar! info@performanceg2.com 9/2/09
附件：
tm1-webinar-2009-11-12-091112154833-phpapp01.pdf (590.51 KB)