mdx returning incorrect results

Post Reply
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

mdx returning incorrect results

Post by Analytics123 »

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.
Wim Gielis
MVP
Posts: 3103
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

Post by Wim Gielis »

Analytics123 wrote: Thu Jul 26, 2018 7:52 pm Do I need specify values for mdx for all dimensions in the cube.
Yes. Or, live with the fact that elements could be taken which you don't want.
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
Post Reply