Hi!

I need a MDX query to show values between dates (DATE dimension: year,
month, day). The report will have country names in the columns and total
sales values in the rows.

Note that my DATE dimension is not populated with all possible dates.


Thanks in advance,
Mário

Check out this posting on my blog...

http://olapmonkey.blogspot.com/2005/...ific-time.html

Now imagine that the [Time].[1997].[Q1].[1] does not exists. What happens
.... ?

Regards,
Mário

"OLAPMonkey (http://olapmonkey.blogspot.com/)" <jjanke (AT) spss (DOT) com> wrote in
message news:1118935081.341403.200500 (AT) g44g2000cwa (DOT) googlegroups.com...