SUMMARY:
This issue has been classified as a defect by Strategy. The impact is limited to Strategy Enterprise Manager 10.x products when trying to run this particular report against a large size intelligent cube. A solution/code fix for this issue is being considered for a future release.
SYMPTOM:
When executing the out-of-the-box Enterprise Manager report "Intelligent Cube Usage Statistics", users may find it error out with an error message similar to below:
Warning: Null value is eliminated by an aggregate or other SET operation
Warning: Null value is eliminated by an aggregate or other SET operation
CAUSE:This is a known issue classified as a defect in Strategy Enterprise Manager 10.x. The cause is due to the size of the intelligent cube exceeding the limit of the INT datatype as defined in the fact object that is used in the metric definition of the metric object "Intelligent Cube Size(KB)" on the report.
ACTION:Contact Strategy Technical Support for an update on the status of the issue. Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
Workaround:
The formula of the "Intelligent Cube Size(KB)" metric can be changed to use an ApplySimple function to change the datatype to BIGINT instead of INT to accommodate for a larger intelligent cube size. An example can be:
Original metric formula - Sum([Intelligent Cube Size (KB)]) {~}
New formula - Sum(ApplySimple("cast(#0 as BIGINT)", [Intelligent Cube Size (KB)])) {~}
