I am fooling with this formulation in the Calculations tab
CALCULATE;
create MEMBER MEASURES.[Sales To Date] as SUM({[Service Date].CurrentMember.Level.Members}.Item(0):[Service Date].CurrentMember,[Measures].[Net Amt]);
-- Use the ITEM() function to return the first member then sum to the currentmember
create MEMBER MEASURES.[Sales Year To Date] AS SUM(YTD(),[Measures].[Net Amt]);
-- Use the YTD() function to sum for Year To Date
create MEMBER MEASURES.[Sales Quarter To Date] as SUM(QTD(),[Measures].[Net Amt]);
-- Use the QTD() function to sum for Quarter To Date
SELECT
{[Measures].[Net Amt],[Measures].[Sales Year To Date],[Measures].[Sales Quarter To Date]} ON COLUMNS,
[Service Date].[Month].Members ON ROWS
FROM [Claims];
but it is not working. the query parses in BIDS ok, but fails to deploy. At first i thought it was the single quotes around the SUM, but i found that the quotes could be removed and still be proper. Still, I cannot get ocver the deploy step because the error im getting is 'Parser: The script contains the statement, which is not allowed. Now, i think there are supposed to be commas between the elements in the SELECT , so im stumbed at the moment
thanks very much
drew