MDX on string filter gives different results

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

MDX on string filter gives different results

Post by Analytics123 »

Hi ,

I have an issue and I am trying to use the below mdx and its giving correct result only for letter grade 'InActive' for all others grades like 'A' to 'F' it gives wrong results .

Even if the grade is 'C' it brings the customer when filtered as ' A'.

MDX :

vmdxFAccountCount='Filter(TM1FILTERBYLEVEL(DESCENDANTS([Customers SoldTo Only].['|vCustomerSoldTo|']) , 0),[AR History].([AR Measures].[Letter Grade],[Currency].[Local Currency],[GL Accounts].[ASSETS],TM1Member( [Months].[Cognos Current Month Reporting].Item(0), [Months]))@=F)';

Executed to see in insert new subset to check if its populating .

Filter(TM1FILTERBYLEVEL(DESCENDANTS([Customers SoldTo Only].[Region - 002]) , 0),[AR History].([AR Measures].[Letter Grade],[Currency].[Local Currency],[GL Accounts].[ASSETS],TM1Member( [Months].[Cognos Current Month Reporting].Item(0), [Months]))@='F')


Any help is appreciated , I am note sure why it would work for InActive Grade alone .
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Re: MDX on string filter gives different results

Post by Analytics123 »

do i need to specify all elements in the cube in the filter .

{Filter({TM1FILTERBYLEVEL(DESCENDANTS([Customers SoldTo Only].[Region - 004 - EVOLUTION - EVOL519]) , 0)},[AR History].([AR Measures].[Total Finance View],[Currency].[Local Currency],[GL Accounts].[ASSETS],TM1Member( [Months].[Cognos Current Month Reporting].Item(0), [Months]))=0)}

My results are coming wrong . I am basically checking the children of a an element which matches the filter .
Post Reply