What is faster from a performance point of view?

Say I had 2 dimensions in a cube and 2 measures, i.e. Dim1, Dim2, Measure1,
Measure2

Method 1

I then to created a Calculated Member for measures

Measure3=0.15
Mesaure4=Measure2*Measure3

Method 2

I created one member in Dim1 called "Variable"


I then to created a Calculated Members as follows

Dim1-Variable, Dim2 - Member1, Measure1=.15
Mesaure4=Measure2*Dim1-Variable, Dim2 - Member1, Measure1

In essence is it faster to calc using one variable multidimensional cell
Dim1-Variable, Dim2 - Member1, Measure1 than applying a sheet approach as
used in Method 2?

Thanks in advance.

Corrections below

Say I had 2 dimensions in a cube and 2 measures, i.e. Dim1, Dim2, Measure1,
Measure2

Method 1

I then to created a Calculated Member for measures

Measure3=0.15
Measure4=Measure2*Measure3

Method 2

I created one member in Dim1 called "Variable"


I then to created a Calculated Members as follows

(Dim1-Variable, Dim2 - Member1, Measure1)=.15
Measure4=Measure2*(Dim1-Variable, Dim2 - Member1, Measure1)

In essence is it faster to calc using one variable multidimensional cell
)Dim1-Variable, Dim2 - Member1, Measure1) than applying a sheet approach as
used in Method 1, i.e. Measure2*Measure3?

Thanks in advance

"Avril" <Avril (AT) ppp (DOT) com> wrote