[Skip Global Navigation]

Training

Training Home

SPSS Trainer Tip: ShowCase® Essbase®

Instructor profile

Name: Jane Black Eagle

About Jane: Jane, a senior solutions consultant, has worked for SPSS since 1997. She has successfully helped numerous SPSS customers solve their business problems through the successful implementation of SPSS products. Jane holds both a BA in business administration and a BS in information systems.

Defining Dynamic Time Series members for the time dimension

You can easily create reports that include year-to-date (YTD) and quarter-to-date (QTD) information by using the Dynamic Time Series function. After you’ve defined the Dynamic Time Series in your outline, you can use it when creating reports in either Excel® or ShowCase Analyzer™.

To defineYTD and QTD ranges, follow these steps:

  1. Select the dimension defined as Time.
  2. Go to the Outline menu, and choose Dynamic Time Series. You'll see the dialog box, Define Dynamic Time Series Members.
  3. For YTD, select Enabled.
  4. For Gen (generation), click the box, and then choose 1 from the list shown.


5. For QTD, select Enabled, and then select Gen2.

6. Click OK to close the dialog box and return to the Outline Editor. The active Dynamic Time Series members are shown for the dimension.


7. Save the outline.

Once you have the Times Series defined, you can use it for your reports. Here is an example in Excel:

 

We offer SPSS courses at locations around the world.
Find a course in the location nearest to you.