MDX no filter in Dimension

[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

[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?

[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 )

[bogdan]

In my view one dimension is filtered based on a second. Okay triggered when the child dimension in view as row