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
Skip to content
  • Register

    • Essbase Date Calc Scripts Error

    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!