Page 1 of 1
SUBNM in active forms
Posted: Fri Feb 03, 2012 4:42 am
by 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.
Re: SUBNM in active forms
Posted: Fri Feb 03, 2012 4:48 am
by 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,
Re: SUBNM in active forms
Posted: Fri Feb 03, 2012 4:53 am
by telula
Nope. Dimension name has no space.
Re: SUBNM in active forms
Posted: Fri Feb 03, 2012 5:56 am
by rmackenzie
telula wrote: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?
Re: SUBNM in active forms
Posted: Fri Feb 03, 2012 12:53 pm
by 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.
Re: SUBNM in active forms
Posted: Sun Feb 05, 2012 10:06 pm
by 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.