I have a time dimension with a Year and month as level 1 and level 2.

I have a property for the month called daysinmonth, I would like to
use the daysinmonth property in a calculation for a calculated measure
as well as in a MDX calculation please advise how I can use it in a
calc measure and the MDX calculation.

Thanks
Measure

Try something like [DimTime].[1997].[jan].Properties("daysinmonth")
The output will always be of string type

- Sank

----- Simon Lenn wrote: ----

I have a time dimension with a Year and month as level 1 and level 2

I have a property for the month called daysinmonth, I would like t
use the daysinmonth property in a calculation for a calculated measur
as well as in a MDX calculation please advise how I can use it in
calc measure and the MDX calculation

Thank
Measur

If you are subscribe to SQL Server Magazine, look at:
http://www.winnetmag.com/Article/Art...384/39384.html

"Member-Properties Boot Camp", by Russ Whitnet, August 2003
10 ways to help member properteries be all they can be

--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sanka" <loonysan (AT) mailcity (DOT) com> wrote