MDX on string filter gives different results
Posted: Thu Feb 15, 2018 5:42 pm
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 .
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 .