There is a requirement to compute the number of days that have passed in a given year (on the current day) for one of our reporting purpose. The reports source Analysis services cube. The cube has a Financial Hierarchy with the following levels : Financial
Year->Financial Quarter->Financial Period->Day
Following is the MDX that has a hard coded value as the day which returns the expected result.
[Time].[Financial Hierarchy].[Financial Year],[Tim
View Complete Post