Topic
7 replies Latest Post - ‏2012-09-21T05:58:25Z by vipirailo
vipirailo
vipirailo
63 Posts
ACCEPTED ANSWER

Pinned topic Getting member name by the alias in TI

‏2012-09-20T17:30:13Z |
Hi, all.
Could you suggest me any function or procedure in TI to get member name by its alias
Updated on 2012-09-21T05:58:25Z at 2012-09-21T05:58:25Z by vipirailo
  • Rizwan.Kaif
    Rizwan.Kaif
    197 Posts
    ACCEPTED ANSWER

    Re: Getting member name by the alias in TI

    ‏2012-09-20T18:06:32Z  in response to vipirailo
    You can use ATTRS() function to get the String/Alias attribute

    
    ATTRS ( dimension ,  element , aliasName );
    


    Cheers!
    Rizwan Kaif
    • vipirailo
      vipirailo
      63 Posts
      ACCEPTED ANSWER

      Re: Getting member name by the alias in TI

      ‏2012-09-20T18:20:52Z  in response to Rizwan.Kaif
      Hi, Rizwan. I've already used ATTRS function but it seems that it's not my case.
      To clarify i have alias name of some member as it stored in cube cell (i mean alias name and not member). So i know what is alias name but don't the name of member itself.
      And this is my trouble
      • Rizwan.Kaif
        Rizwan.Kaif
        197 Posts
        ACCEPTED ANSWER

        Re: Getting member name by the alias in TI

        ‏2012-09-20T18:33:20Z  in response to vipirailo
        So in that case you need to use:

        
        DimensionElementPrincipalName( dimension , Element );
        


        Cheers!
        Rizwan Kaif
        • vipirailo
          vipirailo
          63 Posts
          ACCEPTED ANSWER

          Re: Getting member name by the alias in TI

          ‏2012-09-21T05:28:02Z  in response to Rizwan.Kaif
          Hi, Rizwan
          Is there any function or procedure in Rules doing the same?
          • MichelZijlema
            MichelZijlema
            45 Posts
            ACCEPTED ANSWER

            Re: Getting member name by the alias in TI

            ‏2012-09-21T05:42:06Z  in response to vipirailo
            Hi,

            The function combination DimNm(dimension, DimIx(dimension, element-alias)) wil return the principal element name.

            Michel
            • vipirailo
              vipirailo
              63 Posts
              ACCEPTED ANSWER

              Re: Getting member name by the alias in TI

              ‏2012-09-21T05:58:25Z  in response to MichelZijlema
              Thank you Michel.
              I've already tried this combination but it seems did the syntax error. Just after your post i tried it again and it was complete success, thanks again
  • vipirailo
    vipirailo
    63 Posts
    ACCEPTED ANSWER

    Re: Getting member name by the alias in TI

    ‏2012-09-20T20:16:25Z  in response to vipirailo
    Great! Now i can go a bit further.
    There are some other troubles to be investigated.
    Thank you, Rizwan, for your help