SUBNM in active forms

[telula]

Hello,
I have a cell (D22) with a SUBNM formula. I use that cell to create a subset in view TM1RPTROW($C$12,"srv:dimname",$D$22 & " 0 Level").
This works well in the spreadsheet but in TM1 web, when I double click D22, it says it cannot find the dimension.
Is there something else I should have done?

Thanking ya in advance.

[Olivier]

Hi,

Does the dimension name contains a space ?
I think that might be creating the issue.
(In Tm1 web space are ignored and the dimension is not found in the system without the space name...)

Hope this helps,

[telula]

Nope. Dimension name has no space.

[rmackenzie]

This works well in the spreadsheet but in TM1 web, when I double click D22, it says it cannot find the dimension.

Can you post the exact formula in D22?

[tomok]

Is that the exact formula or are there typos? You have to separate parameters with commas and you don't have one between $D$22 and " 0 Level". Why do you have a blank space before the 0 in 0 level? Please cut and paste the EXACT formula so we can tell whether you are keyboard challenged.

[telula]

Folks, figured it out. The space issue wasnt before the 0 in 0 Level, there was a space betwwen server: and dimname.
Problem solved.