ATTRS rule function returning invalid expression

Post Reply
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

ATTRS rule function returning invalid expression

Post by lynnsong986 »

Hello,

I have this rule that gave me errors:

['BillingMonth']=N:ATTRS('SM_Projects',!SM_Projects,'BillingMonth');

BillingMonth is a string attribute in the format of "YYYY-MM". can someone please let me know what I did wrong here?
ascheevel
Community Contributor
Posts: 312
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: ATTRS rule function returning invalid expression

Post by ascheevel »

is ['Billing Month'] a string measure in your cube? If so, you wrote an N: level rule, try S: instead.
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: ATTRS rule function returning invalid expression

Post by lynnsong986 »

thanks so much, exactly where I did wrong!!
Post Reply