Databases Reference
In-Depth Information
Some UDA rules to keep in mind:
• You can assign many UDAs to a single member, but you cannot assign the
same UDA to a member more than once.
• You can use the same UDA on many different members.
• A UDA cannot be the same name or word as a member name or alias name.
• UDAs cannot be used on Shared Members or members in an
attribute dimension.
• UDAs run with the dimension they were created in and can only be assigned
to other members in that same dimension.
• UDAs are member speciic and only apply to the single member they are
attached to. Parents, children, and so on, of a member assigned a UDA are
not covered unless they also have the UDA assigned to them as well.
UDAs are added to the database outline members in much the same way as adding
an alias or updating any other outline member property. When adding a UDA to an
outline member, Essbase will display a list of UDAs available for the dimension in
which the member resides. If the desired UDA does not exist, you may simply add
it the first time.
Dynamic Time Series
Once again, Essbase gives us a feature so cool that it makes us wonder how we lived
without it! The
Dynamic Time Series
function is one of those features.
We can't think of anyone who wouldn't use this functionality. Likewise, we can't
think of anyone who wouldn't need this functionality.
What the
Dynamic Time Series
does for you is automatically calculate period-to-date
data based on your
Time
dimension. Using our example database for the Esscar Motor
Company, we see that it is probably a good idea to know our year-to-date vehicle
production, by both calendar year and model year. The
Dynamic Time Series
function
does this for you. You can easily calculate period-to-date data for any period as defined
in your
Time
dimension.
