Error in MDX

Post Reply
escape18in
Posts: 26
Joined: Tue Feb 03, 2015 10:22 am
OLAP Product: IBM Cognos BI
Version: 10.2
Excel Version: Excel 2010

Error in MDX

Post 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?
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Error in MDX

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply