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);
tm1 rules problem
-
sairajsoma
- Posts: 1
- Joined: Wed Nov 06, 2024 2:55 pm
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 10
tm1 rules problem
- Attachments
-
- Screenshot 2024-11-06 201843.jpg (63.33 KiB) Viewed 579 times
Re: tm1 rules problem
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
For String Measures, you need to use DB function.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);
Ardian Alikaj