Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    ViewAttrSL function for IBM Planning Analytics (TM1)

      ViewAttrSL returns a string from a cube view’s attribute for a given locale.

      In this video, ViewAttrSL will be used to retrieve the Description attribute from the Employee cube’s default view from the locale, pt-BR.

      Where can the ViewAttrSL function be used?

      TurboIntegrator

        Which TM1 Server version is the ViewAttrSL function available for?

        Version 11 and 12

          What is the syntax for ViewAttrSL?

          ViewAttrSL(CubeName, ViewName, AttributeName, [LangLocaleCode])

          • CubeName = Parent cube of the view to have the string attribute value retrieved.​
          • ViewName = Name of the view to have the string attribute value retrieved.​
          • AttributeName = Name of the attribute to retrieve the value.​
          • LangLocaleCode = Specifies the language code of the attribute to be retrieved (ISO 639-1).​ TM1 will retrieve the user’s locale attribute value if blank or ignored. 

          Relevant Functions

          • ViewAttrDelete = Deletes a view attribute from a cube
          • ViewAttrInsert = Creates a new attribute for a cube view
          • ViewAttrN = Returns a numeric attribute from a cube view
          • ViewAttrNL = Returns a numeric attribute from a cube view for a given language
          • ViewAttrPutN = Inserts a numeric value to an attribute for a cube view
          • ViewAttrPutS = Inserts a string to an attribute for a cube view
          • ViewAttrS = Returns a string from a cube view’s attribute
          • ViewAttrSL = Returns a string from a cube view’s attribute for a given language