Report Portal

Jhon, Please read about dimension types

Jhon, Please read about dimension types here: http://technet.microsoft.com/en-us/library/ms175589.aspx Your Time dimension probably is not specified as time, and attribute for year is not specified as Year. In such case you cannot use YTD. You need to fix structure. Also, you can rewrite this using PeriodsToDate function. Just instead of dealing with attributes start working with hierarchies, that is [Date].[YourHierarchyName].[Month], etc.

 

2007-2015 VidasSoft Systems Inc.