No Measures show data

From DataSelf Knowledge Base
Jump to navigation Jump to search

Fix

Make sure the first entry in Calculations tab is CALCULATE. Drag it to the first position if it has moved. If it is missing, go to a working cube and select CALCULATE. Copy the whole entry in the right hand pane, or just copy this:

/* The CALCULATE command controls the aggregation of leaf cells in the cube. If the CALCULATE command is deleted or modified, the data within the cube is affected. You should edit this command only if you manually specify how the cube is aggregated.

  • /

CALCULATE

In the problem cube, rightclick > *New Script Command* and past in the script from the working cube (or from above).

References

From http://blog.stevienova.com/2009/02/17/ssas-cube-rule-1-you-need-calculate/ SSAS Cube Rule #1 – YOU NEED CALCULATE Written on February 17, 2009 by Steve Novoselac in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

Notes

Ok, I just spent a few hours debugging a cube that wasn’t bringing back any data. Checking all the relationships, the source data, the marts, etc, etc. And lo and behold, find out that a colleague commented out all the calculations, including the CALCULATE statement which says:

The CALCULATE command controls the aggregation of leaf cells in the cube. If deleted or modified, the data within the cube will be affected. This command should only be edited if you intend on manually specifying how the cube will be aggregated.

Remember, you NEED the “CALCULATE” command!