Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    CubeAttrNL function for IBM Planning Analytics (TM1)

      CubeAttrNL retrieves data from a numeric attribute for a cube by language locale.

      In the video, CubeAttrNL will be used to retrieve data from the numeric attribute, Number of Dimensions, for the Employee cube.

      Where can the CubeAttrNL function be used?

      TurboIntegrator

        Which TM1 Server version is the CubeAttrNL function available for?

        Version 11 and 12

          What is the syntax for CubeAttrNL?

          CubeAttrNL(CubeName, AttributeName, [LangLocaleCode])

          • ​​​CubeName = Cube to have the numeric attribute retrieved.​
          • AttributeName = Name of the attribute to pull the information from.​
          • LangLocaleCode = Specifies the language code the attribute will be retrieved from (ISO 639-1).​
            • If blank or ignored, TM1 will pull the user’s current locale.​
            • If attribute value does not exist for the given locale, TM1 will pull the value from its parent. If attribute value for the parent does not exist,TM1 will pull the base value.  

          Relevant Functions

          • CubeAttrDelete = Deletes a cube’s attribute.
          • CubeAttrInsert = Creates a new attribute for Cubes.
          • CubeAttrN = Returns a numeric attribute for a specified cube.
          • CubeAttrNL = Retrieves data from a numeric attribute for a cube, for a given language.
          • CubeAttrPutN = Uploads data to a numeric attribute for a cube.
          • CubeAttrPutS = Uploads data to a string attribute for a cube.
          • CubeAttrS = Returns a string attribute for a specified cube.
          • CubeAttrSL = Retrieves data from a string attribute for a Cube, for a given language.