ViewAttrN function for IBM Planning Analytics (TM1)
ViewAttrN returns a numeric attribute from a cube view.
In this video, ViewAttrN will be used to retrieve the Reference Number attribute, from the Employee cube’s default view.
Where can the ViewAttrN function be used?
TurboIntegrator
Which TM1 Server version is the ViewAttrN function available for?
Version 11 and 12
What is the syntax for ViewAttrN?
ViewAttrN(CubeName, ViewName, AttrName)
- 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.
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