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

Generate data for a range of periods that spread into two years

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

Summary

Generate data for a range of periods that spread into two years

Content

Hi everybody,

I am working on a simple calc script but I can't seem to figure out how to make it work. My goal is to generate data for a range of periods that spread into multiple years. For example, I am trying to enter 0 for an employee starting in June FY17 and ending in Aug FY18. The data will be spread into 3 periods and 2 years. Does it make sense? Our fiscal year starts in Jul.

The cross dim functionality does not work:

FIX ("NoChart1","NoFund","Forecast","Working","E012528498","JC3252","1_14000","Jun"->"FY17":"Aug"->"FY18")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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