ELISCOMP function#
ELISCOMP returns TRUE when the first element is a component (child) of the second - a membership check within a hierarchy.
ELISCOMP is a native TM1 / Planning Analytics function.
Signature#
=ELISCOMP("Server:Dimension", element1, element2)
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | Server:Dimension |
String | Yes | "server:dimension". |
| 2 | element1 |
String | Yes | The candidate child. A numeric value warns but is accepted. |
| 3 | element2 |
String | Yes | The candidate parent. |
ELISCOMP takes exactly three arguments. The default result is FALSE.
What happens when an argument is wrong#
For the shared error model and the Calc Mode effect, see how Reportworq handles errors.
| Situation | Result |
|---|---|
| More than three arguments | Hard error |
| Fewer than three arguments | Warning, FALSE |
| Dimension or either element not found | Warning, FALSE |
Examples#
=ELISCOMP("PlanTM1:Region", "Northeast", "North America")
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- ELISPAR function - test whether one element is a parent of another.
Feedback on this page
Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.
Email feedback on this pageOr write to support@reportworq.com directly.