<div>
Thanks Pedro! &nbsp;Almost as soon as I wrote out my question, I realized that what I really needed was a dimension that is dynamic (changes every month) grouping the last three months. &nbsp;Your comment validates the direction I am now going in. &nbsp;Thanks again
</div>


Thanks Pedro!  Almost as soon as I wrote out my question, I realized that what I really needed was a dimension that is dynamic (changes every month) grouping the last three months.  Your comment validates the direction I am now going in.  Thanks again

<div>
<div class="content wysiwyg-content">
Does anyone know the syntax to create a QTD sum of a measure in SSAS 2005, either by creating a calculated member or setting up a time dimension that dynamically defines QTD groups in a dimension?
</div>
</div>


Does anyone know the syntax to create a QTD sum of a measure in SSAS 2005, either by creating a calculated member or setting up a time dimension that dynamically defines QTD groups in a dimension?

SQL Server Analysis Services (SSAS) 2005 - QTD Calculated member or Time Dimension Hierachy

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.