Page 1 of 1

Error Forming Tuple Expression

Posted: Wed Dec 19, 2012 3:52 pm
by aking
Hey guys, I'm getting an error I haven't seen before and I'm hoping someone can shed some light on it.

I'm trying to attach this MDX query to a time Dimension.

Code: Select all

{FILTER( {TM1SUBSETALL( [Time] )}, [Time].[Month] <> "")}
The attribute exists as a text attribute, and some of the elements have data in the attribute but not all. The message I get is:
Error Forming Tuple Expression

I've tried to copy the expression into the window, I've tried recording a similar expression, and I've tried using a process to attach the expression. All methods give me the same error.

The dimension has an alternate Hierarchy for YTD rollups, could this be causing it?

Thanks for any Insight.

Re: Error Forming Tuple Expression

Posted: Wed Dec 19, 2012 9:59 pm
by Martin Ryan
My guess is that Month is a reserved word. Try another name for your attribute.

Re: Error Forming Tuple Expression

Posted: Wed Dec 19, 2012 11:36 pm
by Wim Gielis
Hello Martin

It works fine (though I would not use these names).

Aking: I guess some kind of ambiguity in the dimension or the rest of the model arises, such that TM1 cannot resolve the expression.
Without seeing your data directory I cannot be more specific. I cannot reproduce the behavior in a limited model.

Re: Error Forming Tuple Expression

Posted: Wed Dec 19, 2012 11:36 pm
by Wim Gielis
Hello Martin

It works fine (though I would not use these names).

Aking: I guess some kind of ambiguity in the dimension or the rest of the model arises, such that TM1 cannot resolve the expression.
Without seeing your data directory I cannot be more specific. I cannot reproduce the behavior in a limited model.

Re: Error Forming Tuple Expression

Posted: Thu Dec 20, 2012 2:32 pm
by aking
Changed the Attribute name to frequency and it seems to be working fine now.

Thanks for the help.

Re: Error Forming Tuple Expression

Posted: Thu Dec 20, 2012 3:55 pm
by Wim Gielis
Most probably because you have that attribute name somewhere else in the model.
Please do not use reserved functions in your object names.