Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

YTD calculations on PBCS data

Question
71
Views
0
Comments
imran.anwar-Oracle
imran.anwar-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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 !

Tagged: