dbTalk Databases Forums  

StrToMember length problems

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss StrToMember length problems in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
samuele.marconcini@neura.it
 
Posts: n/a

Default StrToMember length problems - 11-18-2005 , 07:55 AM







I created a new funcion with

StrToMember(Membername) .

The Membername is FENIT_XXXF1 (char 11).

I had the error message:

Microsoft® OLE DB Provider for Analysis Services error '80040e21'

Formula error - cannot find dimension member ("FENIT_XXXF") - in a
name-binding function

FENIT_XXXF are 10 char.

StrToMember have some length restrictions?


Reply With Quote
  #2  
Old   
Denny Lee
 
Posts: n/a

Default Re: StrToMember length problems - 11-18-2005 , 12:57 PM






The StrToMember function itself should not have any length restrictions or
atleast if it does, its should be far greater than 10 characters. Out of
curiosity, what are you using the StrToMember function for - i.e. within a
calculated member? Not knowing the full MDX statement, it appears that
somehow the calculated member (if that is what is using the StrToMember
function) is translating the membername and then cutting it off and hence
the problem you are seeing. Could you provide a little more detail on how
the function is being used? Thanks!

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



<samuele.marconcini (AT) neura (DOT) it> wrote


I created a new funcion with

StrToMember(Membername) .

The Membername is FENIT_XXXF1 (char 11).

I had the error message:

Microsoft® OLE DB Provider for Analysis Services error '80040e21'

Formula error - cannot find dimension member ("FENIT_XXXF") - in a
name-binding function

FENIT_XXXF are 10 char.

StrToMember have some length restrictions?



Reply With Quote
  #3  
Old   
samuele.marconcini@neura.it
 
Posts: n/a

Default Re: StrToMember length problems - 11-21-2005 , 01:37 PM



Thak you Danny,
I very sorry for disturbing you.
I did a mistake: I defined the field just only of 10 characters.
The only thing I didn't contolled!

Thanks again.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.