說明cognos培訓(xùn)建行c8t

1、Relative TimeCognos 8 BIObjectivesAt the end of this module, you should be able to:compare trends over timeset the current periodcreate relative time categoriescustomize relative time categoriesCompare Trends Over TimeAs dates in your data source change, the data in your report can automatically cha

2、nge to reflect data for the current time period.Transformer automatically creates several standard relative time categories and organizes them into groups so that they are easier to understand and customize.Relative Time CategoriesRelative time categories are special categories that can apply to eit

3、her Standard time or Nonstandard time.Q2SingleQ1Q4Q3Q2Q1Q4Q3Q2Q1Running TotalPeriod-to-DateTodayTypes of Relative Time CategoriesGrouped Relative TimeA group of relative time periods that consists of:prior period-to-dateperiod-to-datecalculation showing changecalculation showing growthTransformer re

4、ads all of the model date values and assigns the latest one as the current period.The current period is the time period that Transformer uses as the benchmark to determine the valid date categories for the relative time categories generated by default. Set the Current PeriodDemo 1Set the Current Tim

5、e Period Manually and Create Additional Relative Time CategoriesCustomize Relative Time CategoriesA custom relative time category is a special category used to track measures over time periods that Transformer does not support.You can create a custom category using one of these basic approaches:Sing

6、le categoryPeriod-to-Date Total or Period-to-Date Total Grouped N-Period Running Total or N-Period Running Total GroupedCustomize: Single CategoryA single time period such as last week. Properties of single category of last weekTarget period: Week Target offset: -1Context period: Year Context offset

7、: 0-今年上周Note: if Context offset was -1, the period would be last year, prior weekCustomize: Period-to-DatePeriod-to-Date is a sequential set of periods, which start at the beginning of a period and end at another specific period, such as Month-to-Date.Properties of month-to-date for the previous 6 m

8、onthsBasic Approach: Period-To-Date TotalTo-date period: MonthTarget period: Week Target offset: 0Context period: Month Context offset: -6N-Period Running Total is a fixed period of time that moves as the current period progresses.Customize: N-Period Running Total6 month running total for 2 quarters

9、 before the current quarter.Demo 2Create a Custom Relative Time CategoryRevenue/ Projected Revenue2006984501200712784762008349560020094325900Date10084477Example (current period set at Dec. 2006): Its projected that by 2009, there will be a four-year total of over $10 million in revenueRevenueProject

10、ed RevenueFuture Relative Time CategoriesDisplay future projections. Your data source must contain future time periods and values.ConsiderationsAvoid multiple time dimensions in a PowerCube.Define the date input format.Limit the range of dates included in the model.If you make modifications to the time dimension only, use Generate Date Categories to update the model, instead of regenerating all the categories.SummaryAt the end of this module, you shou