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 Date Calc Scripts Error

Received Response
20
Views
24
Comments
edited Aug 2, 2018 2:36AM in Essbase 24 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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