I have a query like this:

With set [TimeSet] AS
'{[Time].[All Time].[2004].[12].[31]: [Time].[All Time].[2005].[1].[2]}'

SELECT
{[Measures].[Temp Motor B Lower Pinion Bearing],[Measures].[TimeLevel]
} ON COLUMNS,

{[TimeSet]} ON ROWS

FROM [E0003_Measures]

When I run this query, I'll get data from 31. dec then I get empty cells for
3.jan to 31. jan, and at last I get data from 1 and 2 january.

When I ask specifically for data from 31. dec, 1.jan and 2. jan, the query
supplies me with the right information.

If anyone has a solution for this i would very much appreciate it.

:-)Kjell, Norway

What sort of table is the [Time] dimension built from - what is the Key
at the [Day] level, and is the [Day] level ordered by Key or by Name?


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanx,

I had ordering set to Name instead of Key

"Deepak Puri" wrote: