Page 1 of 1

Error in MDX

Posted: Fri Jan 08, 2016 12:00 pm
by escape18in
Hi All,

I am trying to create a MDX for my subset, when use Record Expression functionality in subset editor is this MDX works fine.

{FILTER( {TM1SUBSETALL( [MY Dimension] )}, [MY Dimension].[ORI] = "ORI")} Here ORI is my Attribute.

When Same MDX i paste it in subset editor expression window i got the below error.

"Get cell value: Cannot resolve cube context expression"

Does anybody know where i am making mistake?

Re: Error in MDX

Posted: Fri Jan 08, 2016 12:10 pm
by Wim Gielis
This works fine for me. Also in the case where "MY DIMENSION" happens to exist as a cube name.
I guess something else is going on.
Please start on a new simple dimension, for instance, few elements, no rules in the }ElementAttributes cube for that dimension, and so on.
Then gradually expand to your "good" dimension.

Also, providing screenshots might help us help you, rather than guessing what the problem might be.