MDX Issue
Posted: Wed Feb 14, 2018 6:01 pm
Hi ,
I am using the below mdx on an insert subset to test the results .
{Filter({TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001]) }, 0)},([AR History].[AR Measures].[Recent Activity],[AR History].[Months].[Feb 2018])=0)}
I want to check the value of Recent activity for all the n level customer under Region 001 for Feb 2018 .
But I am getting an error like
Syntax error at or near '[AR History].[Months].[Feb 2018])=0)}', character position 132 .
Can the filter condition be on 2 dimension values , ([AR History].[AR Measures].[Recent Activity],[AR History].[Months].[Feb 2018])=0)
Should I use something like tuple in cognos .
Any help is appreciated . If that works I will alos need to know count the accounts .
Thanks,
I am using the below mdx on an insert subset to test the results .
{Filter({TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001]) }, 0)},([AR History].[AR Measures].[Recent Activity],[AR History].[Months].[Feb 2018])=0)}
I want to check the value of Recent activity for all the n level customer under Region 001 for Feb 2018 .
But I am getting an error like
Syntax error at or near '[AR History].[Months].[Feb 2018])=0)}', character position 132 .
Can the filter condition be on 2 dimension values , ([AR History].[AR Measures].[Recent Activity],[AR History].[Months].[Feb 2018])=0)
Should I use something like tuple in cognos .
Any help is appreciated . If that works I will alos need to know count the accounts .
Thanks,