SetDimension filter on Level Based Hierarchy

[GST11]

Hello All,

I want to Dynamically pass filter on a Dimension which is a level based hierarchy.
TB_a.getDataSource().setDimensionFilter("[C_c].[abc]", ["[[C_c].[abc].[Level1].&[" + v_xyz + "]"]);

C_c is the Dimension
abc is the hierarchy name
v_xyz  is the dynamic value for this which i want to pass.

but this isn't working, i have tried changing levels it still doesn't work.
i have tried other ways too, it some how doesn't work
Any clues?

@N1kh1l 

[N1kh1l · Accepted solution]

@GST11 

Thanks for the tag. 

For level based hierarchy you should try something like below

var DS= Table_1.getDataSource();
DS.setDimensionFilter("FA","[FA].[Level].&[9307]");

//[FA].[Level].&[9307] -  FA is Dimension Name, [Level] is Level based Hier,9307 is the member

The filter member should be in the pattern "[FA].[Level].&[9307]" which is as below

[DimName].[Level HierName].&[memberid]

Hope this helps !!

Nikhil

[GST11 · Accepted solution]

This Worked!