Oracle Analytics Cloud and Server
YTD calculations on PBCS data
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?