TM1 Forum

Dear All,

Tm1 10.1
Tm1 web

I need to solution for TM1WEB to check if a subset exists for a Dimension. I like to set a default subset for a SUBNM based on the outcome of a check. The name of the subset is concatenated based on some excel cells.

Here an example:

Cell A1: Spain
Cell A2: ProductsA
Cell A3: = "}"& A1 & A2 // would contain "}SpainProductsA
Cell A4: ="DefaultProducts"
Cell A5: IF(SUBSETEXISTS('Products', A3), A3, A4) // if subset }SpainProductsA exists use it, otherwise use the default one.

//SUBSETEXISTS doesn't exist in Web

SUBNM(....,A5,...)

So I need a way to find out if an subset exists via web. I checked SUBSIZ which unfortunately doesn't work in web. I could also create in a hidden sheet an active form based on a subset an check somehow if it was build but this is for me away overhead and costs performance.

Any easy way to fix this?

Hi

Untested, but you could try to do a SUBNM to retrieve the element at index 1. If it comes up as blank, the subset will not exist (or does not contain any elment to which the user has access)

If that SUBNM is in, say, cell A1:

=A1=""

will test if the SUBNM returns anything meaningful. Or, a nicer alternative, do a DIMIX check on the result of that SUBNM formula in cell A1. If DIMIX = 0 ==> error, if DIMIX > 0 ==> valid element/subset.

Again, untested

Works. thanks.

Just a question, does the SUBSIZ function work on TM1Web? Because it should and for me, it does. TM1 10.2.1