I am using Analysis services. Whenever I try to enter a calculated member in
a dimension with several hieararchies (DimensionName.HierarchyName), this
does not work if i select a parent member for the calculated member. The
error message is: "Unable to update the calculated member. object not found
(possibly a dimension member) [and then the formula name appears] - during
the creation of the formula".
The parent dimension an parent member names have been selected from the
lists in the calculated member builder, so there are no typing errors.
Once I remove the parent member, or if I make a similar formula in a
dimension without hierarchies (also with a selected parent member),
everything works fine. Can anyone help with this ?