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

Essbase Studio Drill Thru Custom SQL on YTD - v.

edited Aug 2, 2018 2:36AM in Essbase


Essbase Studio Drill Thru Custom SQL on YTD - v.


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 

Howdy, Stranger!

Log In

To view full details, sign in.


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