Hello everyone,

I'm developing a report in Reporting Services, based on an OLAP cube,
that shows Budgets and
Costs.
As a report parameter i use Posting Period, which is a time dimension
with the levels Year, Quarter, Month, Date.
When you select a value for this parameter, the listbox shows the
folowing values:

All Posting Period
2000
Q3
September
01-09-2000
02-09-2000
....

Because the report user only wants to change values on a monthly level,
I would like to hide the "Date" level, because it gives too much
details. It should be something like this:

All Posting Period
2000
Q3
September
.....

The problem is that the measures become incorrect when I try to hide
this level.
I have tried to set it's visibility to "False" in the cube, i have
tried to create another dimension based on the same data, which shows
only the correct levels, and have been searching for an MDX formula to
filter the dimension levels. So far nothing has worked.

I would like to know whether it's possible to hide a certain dimension
level in the Reporting Services editor (VS.NET), or if anyone has a
solution to do this within the cube or with an MDX formula.

Thanks a lot!