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 .
MDX on string filter gives different results
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- 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
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 .
{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 .