Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Essbase Studio Drill Thru Custom SQL on YTD - v. 11.1.2.4 — 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

Essbase Studio Drill Thru Custom SQL on YTD - v. 11.1.2.4

Question
6
Views
0
Comments
edited Aug 2, 2018 2:36AM in Essbase

Summary

Essbase Studio Drill Thru Custom SQL on YTD - v. 11.1.2.4

Content

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.

Register

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