Message-ID: <22667284.1075845330518.JavaMail.evans@thyme> Date: Mon, 14 May 2001 11:30:32 -0700 (PDT) From: matt.smith@enron.com To: tara.piazze@enron.com Subject: FW: MDX NULL Status Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: Smith, Matt X-To: Piazze, Tara X-cc: X-bcc: X-Folder: \Smith, Matt\Smith, Matt\Sent Items X-Origin: SMITH-M X-FileName: Smith, Matt.pst -----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.