1) I know I can build my own MDX calulations in OWC (office WEB
components) but what is the correct syntax for setting the correct
calulation order in the OWC formula text box.

For example :

-- Budget % Variance
([Measures].[Amount],[Scenario].[Variance]) /
([Measures].[Amount],[Scenario].[Budget])

..... And then , SolveOrder = 5 ?

2) If I export this calulation back to Excel is it possible somehow
to edit the MDX statement somewhere in Excel (2003)

Re
Bjørn T

Another way to go was to put these calc's into the AS cube as calculated
members - then they will be available to everyone accessing the cube - and
not just the one report / page that you are creating at the moment.

<bti (AT) ementor (DOT) no> wrote

1) I know I can build my own MDX calulations in OWC (office WEB
components) but what is the correct syntax for setting the correct
calulation order in the OWC formula text box.

For example :

-- Budget % Variance
([Measures].[Amount],[Scenario].[Variance]) /
([Measures].[Amount],[Scenario].[Budget])

..... And then , SolveOrder = 5 ?

2) If I export this calulation back to Excel is it possible somehow
to edit the MDX statement somewhere in Excel (2003)

Re
Bjørn T