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

Non-Aggregating Statistical Accounts and Weighted Average in Sparse Dims

Accepted answer

Ok Team...

We have a variety of Workforce statistical accounts that we want to report out of an ASO Cube (we technically push the data from WF to FS, then report out of an FS ASO cube).

Some of these accounts should not aggregate at all - such as Hours per Day. This account is mostly "8" in all intersections. But if a report is run at a top level, we wouldn't want all the 8's to aggregate to say 4160 hours per day. It should just say 8. But ASO's cannot have Never consolidation properties. Is there some combo of properties that allow that?

Howdy, Stranger!

Log In

To view full details, sign in.


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