Connection to Olap Cube
 

Hallo

I have a problem with a connection to an Olap Cube from Analysis Services.
I have defined a calculation on the cube that do a Running Tota for a value.
(the mdx expression is SUM(YTD(),[Measures].[Ordinato]))

I have a Hierarchy on Time dimension (year-semester-month)

I connect from excel and put this hierarchy on row and the calculated
measure on values.
When i filter (from row hierarchy) year=2008;semester=1;Month=January i
expect to have my measure calculated on row only for the filtered value.
Insted excel show me the total value for year 2008(not only
semester=1;Month=January ) on his row and the total value for first semester
(not only Month=January) on the correspondent row.
If I analyze a standard measure (no calculation) excel 2007 behave as i
expect.
If i do the same analysis from BIDS or Managment studio connected to same
Cube i have the expected values for all measure.......!

I use Excel 2007 with SP1

Thank You in advance for any help :)

--
IT Professional
--
IT Professional