You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Time Series Analysis using a View dimension

Received Response
edited Mar 8, 2021 11:17PM in Profitability and Cost Management 2 comments


Over the past few months several posters have asked about calculating and reporting on time series values such as YTD, QTD, Trailing 12 months.

The EPM Planning and Close business processes have this built into the Essbase outline as they use the block storage outline (BSO) Essbase databases.  Since PCM uses aggregate storage outline (ASO) databases that do not include this capability built into a time dimension you need to build it into your dimensions yourself.

To help understand this and to boost use of time series reporting in PCM I have provided a sample application that uses the Period dimension to compute XTDs and a View dimension to simplify reporting as well as compute additional tine related values like trailing X months values.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!