PS2007 / Analysis Services 2005 - problem

M

Mike Mahoney

Using AS 2000 I used the following expression to return cumulative manhours

Sum(PeriodsToDate([Time].[All]),[Measures].[Work])

The syntax for AS2005 / SQL 2005 appears to be different for the
PeriodsToDate function. Can anyone help with the appropriate expression.

Thanks

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PS2007 Cube configuration 1
Data Analysis - Cummulative calculations 2
Data Analysis - Cube Calculation 2
How to view S-Curve in PS 2007 and entering the formula 5
can't connect to Analysis Services (PS2007) 3
PS2007 - OLAP Cube - Analysis Services 2005 3
Configuring OLAP Services for SQL 2005 1
Analysis Services eating memory and processor 2

Top