TM1 Function for Excel, ELISPAR
ELISPAR determines whether an element is a parent of a child in a dimension.
Where can the ELISPAR function be used?
Excel, Rules and TurboIntegrator
What is the ELISPAR function?
ELISPAR determines whether an element is a parent of a child in a dimension.
What is the syntax for ELISPAR?
ELISPAR(TM1ServerName:Dimension, ParentElement, ChildElement)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
ParentElement = Name of the parent element or alias
ChildElement = Name of the child element or alias
A demonstration on how to use ELISPAR
From the Product Type dimension, find out if Bikes is the parent of Mountain Bikes.