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?
Error in MDX
-
- Posts: 26
- Joined: Tue Feb 03, 2015 10:22 am
- OLAP Product: IBM Cognos BI
- Version: 10.2
- Excel Version: Excel 2010
-
- 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
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.
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
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