Databases Reference
In-Depth Information
In other words, Essbase can automatically calculate a cumulative number based on
how you have the
Time
dimension set up. If you want to track how many vehicles
you have built from the beginning of the year through the current month, the
Dynamic Time Series
can do this for you. If you were to build 1,000 units in January
and 1,000 units in February, and 1,000 units in March, you would expect to see 1,000
units as your net number for each month's data pulled. But, if you want to know
the total units through each month, you would expect to see 1,000 for January, 2,000
for February, and 3,000 through March. This is what a period-to-date calculation will
give you.
The
Dynamic Time Series
member is actually created for you when you associate a
predefined
Dynamic Time Series
member with the appropriate outline
Generation
.
For example, to use the year-to-date
Dynamic Time Series
functionality, you would
associate a year member with the
Generation 4
(month's level)
Calendar Period
s
dimension. When you request the data at the
Dynamic Time Series
member,
Essbase will automatically sum the
Generation 4
level members within the given
year and return the results to you.
Essbase has provided the following predefined
Dynamic Time Series
functions.
As always, if you have a special need, there are plenty of calculation functions
available to allow you to code even the most complex custom calculation:
•
H-T-D
(History-to-date)
•
Y-T-D
(Year-to-date)
•
S-T-D
(Season-to-date)
•
P-T-D
(Period-to-date)
•
Q-T-D
(Quarter-to-date)
•
M-T-D
(Month-to-date)
•
W-T-D
(Week-to-date)
•
D-T-D
(Day-to-date)
Here is an important item to consider when coding
Dynamic Time Series
functionality. Your
Dynamic Time Series
member can be associated with any
Generation in your time dimension, except the zero level Generation (you cannot
have months adding upto a month-to-date value).
The steps to add a
Dynamic Time Series
member to the
Time
dimension of
our Esscar database outline are:
1.
In EAS, open the Esscar outline in the outline editor
2.
Click on
Outline
|
Dynamic Time Series.