TM1 Forum

Good morning everyone,

I have a little problem. I want to test if a specific element is present on specific dimension. Some one has an idea of which formula may I use ?

Thank's a lot for your help

beber005 wrote: I have a little problem. I want to test if a specific element is present on specific dimension. Some one has an idea of which formula may I use ?

You're asking that after reading the following part of the Request For Assistance Guidelines, and taking even a couple of minutes to look at the Reference Guide?

Also, please don't ask very basic questions about how to do things in TurboIntegrator or Rules without at least looking through the relevant functions in the Reference Guide.

Hint: Rules Functions => Element Information Rules Functions.

Or alternatively, since you also skipped over guideline 2

2) Ensure that you specify the component of the software that you're having a problem with. If someone states that they have a problem with number formatting, people need to know whether that's in Cube Viewer, Web, EV, the API, or wherever.

and we have no idea where you want to obtain this information from, Worksheet Functions.

Yes I have read this document I'm not stupid you know. I think I need to use the formula "DIMIX" to test if in my dimension the element X exists or not

beber005 wrote:Yes I have read this document I'm not stupid you know. I think I need to use the formula "DIMIX" to test if in my dimension the element X exists or not

This is what the document says:
"DIMIX returns the index number of an element within a dimension."
...
"If the element is not a member of the dimension specified, the function returns 0."

If you really did take a couple of minutes to read the documentation before posting your question, perhaps you'd care to clarify the following points:
(a) Why you made no mention of finding DimIx in your first post; and
(b) Which part of the above quotes you found unclear or ambiguous, and caused a need for you to ask people to spend their valuable time telling you the same thing that you claim you had already found in the documentation.

This isn't exactly the first time that you haven't followed the guidelines. Guidelines which, incidentally, are in part intended to ensure that people don't abuse the help on offer here.