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