Issue with Rules and Strings

[aking]

Hey guys, I'm looking for some help on what I thought would be a rather simple thing.

Every time I try to attach this rule, I get an error for an Invalid Expression, starting at ['Actual':

Code: Select all

['Forecast1','String Value'] = S: ['Actual','String Value'];

To me, that looks like a fairly simple and straight forward thing, so I'm wondering if there is some obscure TM1 caveat that I'm missing. I basically just want to say, "For this scenario, string measure get the value from that scenario, string measure."

If I set the rule to a Literal, like this:

Code: Select all

['Forecast1','String Value'] = S: 'Hello World';

it works fine. This:

Code: Select all

['Forecast1'] = ['Actual'];

also works, but only for Numeric values. I've also tried breaking that third rule up into S: and N: rules. No dice.

I'm working in a small dev cube so that I can port this to a larger cube, so there are no other rules on the cube. Is there something obvious I'm missing?

Thanks in advance for any help.

I'm running 10.1

[declanr]

You need to use longhand DB refs for strings in TM1. The shorthand notation works for numerics but not strings as you have already found.

[aking]

Yep, just tried that and it went through. Thanks.