OLAP : Different calculation from Excel an BIDS

G

Gianluca71

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 :)
 

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

Top