Non visible level in Dimension

[Tom2]

I have a dimension [Reporting Date] which has the following levels..

[Reporting Date]
[Year]
[Quarter]
[Month]

If I make set the property of "Visible" to false for month, am I still able to use it in calculations? If so, how do I reference it?

I tried the following:

[Reporting Date].CurrentMember.[January]

and it gave me a name-binding error when I tried to view the data.

Thanks in advance

 

[Shab]

I think the solution is to make your calculated member first and then hide the level. Though I haven't tried exactly what you are doing but I have calculated measures that are based off of hidden measures. If I try to make these calculated members while the base measure is hidden it gives me errors. So I make the calculated member first and then hide the base one.
Hope it helps.

Shabnam

 

[Tom2]

I think I should have been more specific..

I am trying to use this in a custom rollup formula.

It'll give me the error no matter when I define the MDX for the custom rollup formula.

I thought that there may have been some other way to reference the non visible level in the dimension so it wouldn't give me the error.

Thanks in advance