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