MDX - Datetime functions

#1

I have 2 datetime measures. Would like to create a MDX formula what
calculates lead time. (Date 1 minus Date 2). Is there a datediff function or
how would I calulcate that. Tried Date 1 - Date 2 and did not work?

#2

Since DateTime values aren't typically used for aggregated measures,
could you explain how these measures work, with sample data to
illustrate?

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX - Datetime functions

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX - Datetime functions - 10-20-2006 , 02:47 PM

Re: MDX - Datetime functions - 10-20-2006 , 08:12 PM