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 » Thu Jul 26, 2018 7:52 pm

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: 2262
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: mdx returning incorrect results

Post by Wim Gielis » Thu Jul 26, 2018 8:01 pm

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

Post Reply