Essbase Date Calc Scripts Error
SummaryEssbase Date Calc Scripts Error
I have a situation where I would need to build a Salary Calculator in Essbase cloud. As of now, even after enabling typed measures, Oracle has not yet been able to provide Date data type.
So is there a workaround to find the difference between Dates (yyyymmdd) using count and range functions?
I have a Period dimesnion as---> 18PP1, 18PP2, etc each PayPeriod has --->14days(20180622,..etc).
I used a following Calcscript:
FIX("00064607","Spano,Richard Niles","IT CABLE PLANT ENGINEERING","Rankey Eugene","Base","Forecast")
"Datediff" = @COUNT(SKIPNONE, @RANGE(Period,("20150619", "20150626")));
I want to find difference between two DATES(YYYYMMDD) entered by the user through Smartview. May be a runtime prompt.