This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Concatenate function

July 14 2012 at 10:31 AM
No score for this post
Arik 
from IP address 173.63.28.65

Hello, Gurus! I am trying to use @concatenate function to buil a name and use it in FIX as as well as aggregation statements:
while using it within FIX works fine :
FIX(@DESCENDANTS(@MEMBER(@CONCATENATE ("X","Y")),0))
I am getting validation error when trying to aggregate this portion of hierarchy using
@DESCENDANTS(@MEMBER(@CONCATENATE ("X","Y"))) ;
The error is:
Detail: Cannot calculate. Essbase Error(1012004): Invalid member name [@MEMBER(@CONCATENATE("X","Y"))]
I tried all combinations of using @member and @name functions...Any suggestions?

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Concatenate function - Javier on Jul 14, 2012, 4:06 PM
    1. Re: Concatenate function - Arik on Jul 14, 2012, 5:06 PM
      1. Re: Concatenate function - Javier on Jul 14, 2012, 5:46 PM
        1. Re: Concatenate function - Arik on Jul 14, 2012, 8:20 PM
          1. Re: Concatenate function - Javier on Jul 14, 2012, 8:35 PM
            1. Re: Concatenate function - Javier on Jul 14, 2012, 8:42 PM
              1. Re: Concatenate function - Arik on Jul 16, 2012, 10:49 AM
     
  2. Are you really trying to do this? - John A. Booth on Jul 16, 2012, 10:57 AM
    1. Re: Are you really trying to do this? - Arik on Jul 16, 2012, 11:20 AM
      1. I don't think it will work. - SK on Jul 16, 2012, 3:13 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.