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

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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