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

YTD calculations on PBCS data

edited Feb 24, 2020 5:23AM in Oracle Analytics


Hello Everyone,

I am building dashboards in DV (oracle managed) on top of PBCS dimensions and data. PBCS provides Dynamic Time Series functions (YTD, QTD, MTD etc.) out of the box but these functions don't seem to be accessible from within DV.

Since PBCS has separate dimensions for Years and Periods, hence it is not possible to create calculations within DV to derive YTD numbers due to lack of a proper Time dimension.

Is there any other way YTD, QTD etc be generated on top of PBCS data?

Thanks !

Howdy, Stranger!

Log In

To view full details, sign in.


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