January 19, 2009 at 3:51 am
Hi,
The following query returns MEASURE_AGGREGATOR column with integer values...
CALL ASSP.Discover('MDSCHEMA_MEASURES')
Any idea what 1, 2, 8 & 127 values indicate in this column?
Regards - JL
January 19, 2009 at 8:54 am
You can do a lookup on this within the SQL Server BOL "MDSCHEMA_MEASURES Rowset" - http://msdn.microsoft.com/en-us/library/ms126250.aspx
An enumeration that identifies how a measure was derived. Can be one of the following values:
MDMEASURE_AGGR_SUM (1)
MDMEASURE_AGGR_COUNT (2)
MDMEASURE_AGGR_MIN (3)
MDMEASURE_AGGR_MAX (4)
MDMEASURE_AGGR_AVG (5)
MDMEASURE_AGGR_VAR (6)
MDMEASURE_AGGR_STD (7) identifies that the measure was derived from an aggregation function that was SUM, COUNT, MIN, MAX, AVG, VAR, or STDEV, respectively.
MDMEASURE_AGGR_CALCULATED (127) identifies that the measure was derived from a formula that was not any single function above.
MDMEASURE_AGGR_UNKNOWN (0) identifies that the measure was derived from an unknown aggregation function or formula.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply