Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
YTD calculations on PBCS data — Cloud Customer Connect
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

Question
12
Views
0
Comments
edited Feb 24, 2020 5:23AM in Oracle Analytics

Content

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.

Register

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