I have a scenario dimension with one member 'ACTUAL' that repeats on
every row in the source table. I would like to add a calc. member in
the scenario dimension that, when chosen, will modify any measure by
an adjustment factor (member called 'ADJUSTED'). The factor is
another column in the source table. So the end result would be 'any
measure'/'adjustment factor'.

Appreciate any help on the approach or MDX syntax, thanks.

If the adjustment column is in the fact table you can create a hidden
measure and then create a calculated member that uses this hidden measure.
If the adjustment column is in a dimension table, you can create a member
property and use that in your calculated member.

If the adjustment column is in the fact table, you can also define a regular
measure and use a SQL expression in the measures SourceColumn property to do
the calculation. This calculation needs to be in the syntax of the
appropriate data source's SQL. This has the advantage that the calculation
will occur only once at processing time which will help query performance.
However, since this calculation is simple and can be applied after
aggregation as a calculated member there will probably be very little
difference in performance.

Hope this helps,
- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"switherman" <switherman (AT) hotmail (DOT) com> wrote