Essbase Studio Drill Thru Custom SQL on YTD - v. 188.8.131.52
SummaryEssbase Studio Drill Thru Custom SQL on YTD - v. 184.108.40.206
Hi to all,
We are recenlty migrated from EIS to essbase studio, we use SQL server. We build our dimensions in a parent/child fashion.
We are told from Oracle that there is a product limitation and we cannot use DTS (Dynamic Time Series), so we had to add a View dimension
with the Periodic, and Y_T_D members.
Our issue is our users want to be able to drill thru on YTD members (We have Periods dim with Year/Qrt/Month), on our tables we do not have View dimension