using variable in cube ? 1

[apad]

Hi

I created a Calculated Member nammed PriceAfterTaxes =
PriceBeforeTaxes x 0,196

I want to create several Calculated Member using Taxes Value (0,196 in this example)

Can I create a variable "Taxes" with the value 0,196 and use it in the formulas of my cube ?
My goal is to change only one time the value of "Taxes" if I need. If I use 0.196 in all formulas, I should modify all formulas.

Thanks

 

[johnherman]

I think you can create a calculated member, then use that calculated member in other calculations. Then you only need to change the assignment value in the calculated member.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[apad]

I created Calculated Members "Taxes" (= 0.196) and "PriceAfterTaxes" (=PriceBeforeTaxes x Taxes).

Now, can I modify the value of "Taxes" and refresh my cube by programming with Visual Basic ?

An answer would be nice, a code sample would be great ...

Thanks

 

[johnherman]

I have never used VB to refresh/update a cube. You could try posting another question in this forum under that topic.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright