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
Which TM1 Server version is this function available for?
Version 11 and 12
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.