Hello,

Imagine a report with VAR1 and VAR2 as class variables and VAR3 for
measure.
I want to calculate the sum of VAR3 by VAR1 and display that report:

VAR1 VAR2 VAR3 SUM
A a 10 20
A b 5 20
A c 5 20
B a 20 22
B d 2 22

thks for your replies.

It's a bit hard to answer specifically without knowing a few more
details. I assume var1 and var2 are levels of some dimension, but are
they in the same dimension or different dimensions?

You should be able to create a calculated member that looks something
like the following

SUM([<dimension>].VAR1.CurrentMember,[Measures].VAR3)

Which may work. If this does not work and you don't want to disclose
more details about the structure of your cubes, maybe you could come up
with a similar scenario for the FoodMart 2000 sample cube.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1127375822.075695.212610 (AT) z14g2000cwz (DOT) googlegroups.com>,
xav29atao (AT) yahoo (DOT) fr says...

Hello,

you put me on the right way:

I change my hierarchy used for query the cube and it works well.
I was unable to provide my cube structure because it's not a "sqlserver
cube"

Thks

Xavier