Days per Month in FCCS Calculation Manager - Leap Years

Summary:

We would like a dynamically calculated member in our ACCOUNT dimension that will compute the number of days in a given PERIOD and aggregate appropriately in concert with the YEARS and VIEW dimensions.

We have a business need to compute a unit per day metric. The member should be able to be retrieved in Smart View or REPORTS

The metric must take into consideration leap years.

Content (required):

When a user selects the following dimension members (PERIOD: Jan, YEARS: FY23, VIEW: Periodic) we want the calculated member to render 31.

When a user selects the following dimension members (PERIOD: Feb, YEARS: FY24, VIEW: Periodic) we want the calculated member to render 29.