@Range function Help!
Summary@Range function Help!
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).