Enron email

Algorithmic Indexing

14 May 2001, 18:30 UTC

FW: MDX NULL Status

From
Matt Smith matt.smith@enron.com
To
Tara Piazze
Date
Mon, 14 May 2001 11:30:32 -0700 (PDT)

The sender added no text of their own; everything below is quoted or forwarded.

Quoted or forwarded from earlier messages
-----Original Message-----
From: 	Alexander, Kim D  
Sent:	Monday, May 14, 2001 10:01 AM
To:	Tonks, Colin; Gaskill, Chris; Smith, Matt; Reitmeyer, Jay
Subject:	MDX NULL Status

Eliminating the effect NULL values have on MDX AVG's in History is progressing but has been filled with additional problems.

The solution to divide the sum from the cube by the count of nonnull days from SQL is practically done. In addition to 
all day Friday.  Five hours were put in over the weekend.  Much of this time has been spent resolving the underlying problems
that pose a problem to consistiency of results..

Done:
Develop query -- spRPT_GetAllDaysWithData
Parameterize query
Modify Program structure to call query with necessary parameters
Determine most complete cycle to use (Get cycle with most number of days of data) 
Verify Queries -- Started

To Do:
Determine how to use all retrieved cycles in NonNullDaysCount query.
Prove this approach is workable.