Hi,
we are using the name path algorithm to let AS2K generate the unique names
(DBPROP_MSMD_MDXUNIQUENAMES = 1), when we operate on a SCD2 dimension, when
reading one cell value containing the name of an aggregated member, which is
in the hierarchy multiple times, sometimes AS2K returns:
Translated to English:
Cannot find dimension member in a function with name-binding
Original error in German: Microsoft® OLE DB Provider für Analysis
Services:Formelfehler - kann Dimensionselement nicht finden
("[Dimension].[Hierarchy].[xxx].[yyy].[201700 zzz]") - in einer Funktion
mit Namensbindung

It seems as if AS2K is unable to solve its own unique names in this
scenario.

Any idea?
Frank

The problem could be that the member has moved. The full path form of
unique names are not stable to changes in the dimension since if anything
along the path is changed the unique name will no longer be able to be
resolved. Check that "2001700 zzz" is still named "2001700 zzz" and still
exists under yyyy which is still under xxx.

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

"Frank Samuel" <FSamuel_nospam (AT) misag (DOT) com> wrote