Error Forming Tuple Expression

[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.

[Martin Ryan]

My guess is that Month is a reserved word. Try another name for your attribute.

[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.

[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.

[aking]

Changed the Attribute name to frequency and it seems to be working fine now.

Thanks for the help.

[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.