mdx returning incorrect results
Posted: 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.
{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.