TM1 Forum

Hi,

we're running TM1 Planning Analytics and I try to realize a couple of SUBNMs to choose different Elements from the same Dimension. In Excel it looks like:
If I select an Element in one of the SUBNMs in TM1Web it looks like:
That means that the selection is written in every SUBNM. The formula looks like:
The Index $C165 is different for every line to get different initial values. But the referenced cells are not filled during the Selection. I even tried to use different Dimension-References. Means: same content because it's the same dimension, but different cell-references. But it's still the same that the cells are all filled.

Any idea why this happens and how to avoid?

Thx and best regards.

Hello,

Just for testing, does it work it work if you hardcode the first 2 parameters in the SUBNM ?

I‘ll try in the Evening today. Thx

Interesting. That's working. I'll make further Tests tomorrow. I Need a dynamic Name für the subset and the index.

The problem is most likely due to the ampersand &. I’ve experienced issues in TM1Web with concatenation, particularly when building MDX queries dynamically.

Try putting into a separate cell and referencing that cell instead.

That makes no difference.

I changed it now to one SUBNM with a TI-button to transfer the value. The button was already there with a slighty different meaning but it's okay. The user can live with ist.

But there is still a problem in TM1Web with a SUBNM and the Index-Parameter. When I have a bit more time I'll try to break it down.

Thx to all suggesting a solution.