Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    ViewAttrNL function for IBM Planning Analytics (TM1)

      ViewAttrNL returns a numeric attribute from a cube view for a locale.

      In this video, ViewAttrNL will be used to retrieve the ‘Reference Number’ from the Employee cube’s default view for the locale pt-BR.

      Where can the ViewAttrNL function be used?

      TurboIntegrator

        Which TM1 Server version is the ViewAttrNL function available for?

        Version 11 and 12

          What is the syntax for ViewAttrNL?

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

          • CubeName = Parent cube of the view to have the numeric attribute value retrieved.​
          • ViewName = Name of the view to have the numeric 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