Hi I am using below mdx to get a list of customers whose grade is D and and type is not 'DST1' from region 1
{Filter({TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Customers SoldTo Only].[All Regions].[Region - 001]}, ALL, RECURSIVE )}, 0)},([AR HISTORY].([AR Measures].[Letter Grade],TM1Member( [Months].[Cognos Current Month Reporting].Item(0), [Months]))@='D') AND ([Customers SoldTo Only].[Type] @<> 'DST1'))}
Cube name is AR History. THere are more dimensions but I am looking only on month and letter grade.
Results not giving accounts that pass this condition.
Do I need specify values for mdx for all dimensions in the cube.
mdx returning incorrect results
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- MVP
- Posts: 3118
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: mdx returning incorrect results
Yes. Or, live with the fact that elements could be taken which you don't want.Analytics123 wrote: ↑Thu Jul 26, 2018 7:52 pm Do I need specify values for mdx for all dimensions in the cube.
For instance, element with index 1 in the dimension. So I would use values for the other dimensions too.
Best regards,
Wim Gielis
IBM Champion 2024
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
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