How to calculate number of days in month?

[bvk.cognoise]

Hi  Mates,

I need some help to calculate number of days in selected month.

i am using cube as source,my requirement is whenever i select a month in prompt i want to see the number of working days in that particular month(except sunday,saturday).for rg:if i select a month in prompt how to calculate number of days in this month.

please help me in this.this is something very importent soloution which i need.



Thanks
bvk

[CognosPaul]

Easiest way would be to create an attribute with that value. Does your month have days as descendants? You might be able to do something like count(1 within set filter(descendants(currentMember([Cube].[Dim].[Time Hier]),[DayLevel]),[Cube].[Dim].[Time Hier].[DayLevel].[Long Name] not in ('Saturday','Sunday'))