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

@Range function Help!

edited Aug 2, 2018 2:36AM in Essbase 17 comments

Summary

@Range function Help!

Content

Hello,

I have requirement to find the number of working days(M-F) for some Employees and for some its (S-S) between two dates(entered in YYYYMMDD) formart in the smartview by the user. Unfortunately, we do not have "DATE" datatype in Essbase cloud yet.

So to workaround this, I have created an Employee dimension which has UDA as 10 for (M-F) or 14 for (S-S). My time dimension has biweekly pay periods--->each day in YYYYMMDD format which are tagged as 1 for all (M-F) and 0 for the weekends(Sat&Sun).

I'm planning to use @Count and @Range

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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