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

ASO Sum crossjoin syntax

in EPM Platform and Freeform 25 comments

Summary:

We are attempting to implement a Trailing Twelve Months/Last twelve months in our ASO cube. We have a working formula in our BSO cube that is producing desired results. We are getting a valid formula in our ASO, however, it is not producing any results. Any help would be greatly appreciated.

Content (please ensure you mask any confidential information):

We have a CurrYr_LTM hierarchy with 12 children. The SubVars are the same for both cubes. I can confirm that the data exists for the Periods i am attempting to sum.

Formula that validates but produces no results is listed below for March:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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