TM1 Forum

Hi Everyone,

I am working on a rule ...the purpose of this rule is to populate values for target (s) element ...when blank or no value is found for Source with elements in !dim1.

I think we cant use direct !dim1 to populate elements...is there any way to populate elements?

[ 'Target'] = S:IF(['source'] @ =' ', !dim1,STET);

note: !dim has n elements
Target has s elements.

Thanks in advance.

Hello

You'd better use the DB( ) notation instead of ['Source']
Next to that, it should work.

Can you please avoid using "Need help" in the topic title?
Everyone who posts a topic, needs help.

Wim

Wim Gielis wrote:Everyone who posts a topic, needs help.

Nah, not everyone. Some posters never bother to come back to either give more details or simply say thank you, which leads me to the conclusion that they never required help in the first place.

Thank you! Wim and qml for the quick response.

Now, I am facing invalid string element expression issue.

[ 'Target'] = S:IF(['source'] @ =' ', !dim1,STET);

here ['target'] is having s elements and !dim1 has n elements.

But the !dim1 has 'n' elements throwing error has invalid string elements expression.

You need to use a DB to get at the string cell and not a [...] reference, even though it is in the same cube. [...] can only be used to return a number.

Thank You! Duncan, Wim and qml

now,i was able to resolve it.