Page 1 of 1
MDX no filter in Dimension
Posted: Thu Nov 13, 2014 2:28 pm
by bogdan
Hello.
I have a MDX query which filters one dimension [CAPEX OPEX Accounts] for the selected dimension item [CAPEX-OPEX]. When the dimension [CAPEX OPEX Accounts] in View as ViewRowDimension, the filtering works, but when ViewTitleDimension the MDX does not work? Tell me how to solve the problem?
Code: Select all
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [CAPEX OPEX Accounts] )}, [CAPEX-OPEX].CurrentMember.Name)}, ALL, RECURSIVE )}, 0)}
Thansk
Re: MDX no filter in Dimension
Posted: Thu Nov 13, 2014 11:15 pm
by rmackenzie
Is that even a valid bit of MDX? This gives me an error:
Code: Select all
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Year] )}, [2015].CurrentMember.Name)}
Did you test the individual components of the statement, at all?
Re: MDX no filter in Dimension
Posted: Fri Nov 14, 2014 3:23 am
by EvgenyT
Code: Select all
that even a valid bit of MDX? This gives me an error:
Code: Select all
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Year] )}, [2015].CurrentMember.Name)}
Did you test the individual components of the statement, at all?
Yes, its correct. You have missed }) on the end, i.e {TM1FILTERBYPATTERN( {TM1SUBSETALL( [Year] )}, [2015].CurrentMember.Name)} )}
However, I am failing to see how this mdx
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [CAPEX OPEX Accounts] )}, [CAPEX-OPEX].CurrentMember.Name)}, ALL, RECURSIVE )}, 0)}
is relevant in the context of the cube view? (but then again it is friday afternoon )
Re: MDX no filter in Dimension
Posted: Fri Nov 14, 2014 8:54 am
by bogdan
In my view one dimension is filtered based on a second. Okay triggered when the child dimension in view as row