Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

TREND Script

edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

TREND Script

Content

Hello,

 

I am trying to create a pretty simple trending script in Essbase using some statistical data from a public source. The gist is I want to trend the data based on an x amount of previous periods for the year, and I want to do it in a separate scenario from what I am loading data to.

 

FIX("2016", @CHILDREN("Natural Gas"), "No Region", "Cubic Metres", @CHILDREN("Canada"), "Local_")

        DATACOPY "Actual"  to "Forecast";

ENDFIX

 

FIX("Forecast", "2016")

SET CREATENONMISSINGBLK ON;

    "Imports"

            (@TREND(@List(Jan:&CurMnth),,,

                    @RANGE(ErrorLR,),

                           ,

                                    &NexMnth:Dec,LR,12););

AGG(Entity,Units,Region);

ENDFIX

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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