tm1 rules problem

Post Reply
sairajsoma
Posts: 1
Joined: Wed Nov 06, 2024 2:55 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 10

tm1 rules problem

Post by sairajsoma »

skipcheck;

'base annual pay' and 'worker type' are element of measure dimension. 'worker type' is string element having 'a' value at one intersection. while saving rule i am getting syntax error. could anyone find the error.

['base annual pay']=N:if(['worker type']@='a',0,1);
Attachments
Screenshot 2024-11-06 201843.jpg
Screenshot 2024-11-06 201843.jpg (63.33 KiB) Viewed 580 times
glaurens
Posts: 43
Joined: Thu Jan 08, 2009 3:42 pm

Re: tm1 rules problem

Post by glaurens »

Use the DB() format when referring to a String measure
ardi
Community Contributor
Posts: 162
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: tm1 rules problem

Post by ardi »

sairajsoma wrote: Thu Nov 07, 2024 5:27 am skipcheck;

'base annual pay' and 'worker type' are element of measure dimension. 'worker type' is string element having 'a' value at one intersection. while saving rule i am getting syntax error. could anyone find the error.

['base annual pay']=N:if(['worker type']@='a',0,1);
For String Measures, you need to use DB function.
Ardian Alikaj
Post Reply