Essbase Date Calc Scripts Error

@COUNT(SKIPNONE

Summary

Essbase Date Calc Scripts Error

Content

Hello,

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")));

ENDFIX

I want to find difference between two DATES(YYYYMMDD) entered by the user through Smartview. May be a runtime prompt.