This content has been marked as final. Show 2 replies
SET AGGMISSG ON missing
SET AGGMISSG specifies whether Analytic Services consolidates #MISSING values in the database. The default behavior of SET AGGMISSG is determined by the global setting for the database, as described in the Database Administrator's Guide.
i guess you period is Dense
I think NextLevel might be referring to the 0 Dense Reads, Writes and Calcs in the calculator information message from the second example (at least, that's what would I be wondering about).
NextLevel - given that your scripts contain 'SET MSG DETAIL' I'm pretty certain you've heavily edited them down. You have probably missed an additional calculator summary message block further up the log in the second example. Search the log on 'Dense Calculations' and you'll find it.
If this isn't the difference you're asking about, please clarify.