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:
Tagged:
0