refresh/update a cube with VB

[apad]

Hi

I would like to modify Calculated Member formula by a program. Is it possible with Visual Basic ?
Is it possible to refresh a cube with a VB command ?

Sample code would be appreciated.

Thanks

 

[MDXer]

You can Rebuild the Cube using VB and DSO (the PI for Analysis Services. A better Method may be to use a a Tax dimension that is hidden in your cube and referenced by the Cube. You can then process the cube and tax dimension and have the Calc reference the Dimension member. Or for ease of use have the tax dimension as a visible dimension with a range of tax values possibly boken into some hierarchy Say Fed, State, Local, Sales etc etc. And allow the user to interact with the dimension making the calculation useable by all tax members.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[apad]

My real problem is to pass values to my cube.

These values are like parameters which alter cube behaviour and results. They have only one value at a time. Tax is one of them, CurrentWeek is another ...

Storing these values in Calculated Member and updating formula with Visual Basic seem to be an easy way for me.

If there is a better practice to do this, I am interested.