Adding average makes all metrics blank

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Adding average makes all metrics blank

Adding average makes all metrics blank

Rate Topic

Display Mode

Topic Options

Author

Message

Mike Austin-398977

Posted Friday, November 02, 2012 11:53 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:54 PM
Points: 28, Visits: 133

All,

I have a SiteCharacteristic fact table surrounded by a SiteDimension, CharacteristicDimension and ZipCode (Geography) dimension. There is a single fact, the CharacteristicMeasure. When I create a cube with the Sum and Counts of this measure, everything appears to be OK. However, I would like to include statistical metrics such as mean, standard deviation, etc., so I started out with a calculation for the mean (average). Here is my calculation:

CREATE MEMBER CURRENTCUBE.[Measures].Averages
AS [Measures].[Characteristic Measure] / [Measures].[Site Characteristic Fact Count],
FORMAT_STRING = "Standard",
NON_EMPTY_BEHAVIOR = { [Characteristic Measure], [Site Characteristic Fact Count] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Site Characteristic Fact' ;

When I add this, *all* the measures return blank. (I've done 20-25 simple cubes in my career, but most were in 2000 or 2005, and I'm obviously not current on this stuff.)

Any help appreciated.

TIA,

Mike

Post #1380539

sqlizer

Posted Tuesday, November 13, 2012 12:09 AM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, April 12, 2013 12:23 PM
Points: 606, Visits: 587

Hello there, did you find solution to your problem? If you did can you pls share your solution?

Thanks

Post #1383955

« Prev Topic | Next Topic »

Permissions