Selecting your own member-filter in CV

Question

My dept wants the ability to search data across region, district, and branches. I was wondering what would be the best way to build that functionality.
Currently, I have build a Select Region Parameter, which has a BR rule running these cases (member filters). And it only shows region level data.&nbsp;
&nbsp;

This is how our report looks like. (Data is omitted)&nbsp;

&nbsp;
However, I'm looking add an option to select districts and branches, Maybe the QV can have a button to add additional rows, by clicking "+" and selecting those specific branches from a dialog box. Or maybe a dialog box, which prompts the user to build their own entity member filter. Hope that gives an idea of where I'm heading.
Any suggestions or ideas will be appreciated. Thank you!
&nbsp;
&nbsp;
&nbsp;

Mustafa_A · Answer

Just an update:I created a member dialog parameter, that let's you select a entity one at time. But I would like if if I could add more filters in, such as selecting one region, a specific parent branch (rollup) underneath it.&nbsp;&nbsp;As shown below, it just throws everything under North Central Central (because I have use Tree Inclusive expansion). But wondering if there is a clean way to do this?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

ckattookaran · Answer

You could use a dashboard with either a multi-select list box or multi-select Combobox to let the users select multiple entities.

Mustafa_A · Answer

Hi&nbsp;ckattookaran&nbsp;&nbsp;I tried setting up a combo box. I'm a bit lost on this. Would you please share any examples that might be out there?&nbsp;&nbsp;&nbsp;

ckattookaran · Answer

I wrote a blog post on this a while back. However, that was a while ago when Multi-Select was not a thing.
Multi-Member selection in Cube View - CPM Insights
Now for this one, create an XFBR and call it in place for Entity. XFBR(YourRule, GetMemberSelection, DimType=Entity,Members=[|!yourentityparam!|])
&nbsp;
Private Function GetMemberSelection(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal args As DashboardStringFunctionArgs) As String
	Try
		Dim strMbrs As String = args.NameValuePairs.XFGetValue("Members")
		Dim strDimType As String = args.NameValuePairs.XFGetValue("DimType")
		Dim retValue As String = ""
		If Not String.IsNullOrEmpty(strMbrs)
			Dim mbrList As List(Of String) = strMbrs.Split(",").Select(Function(x) x.Trim).toList()
			retValue = $"E#{String.Join(", E#", mbrList)}"
		Else
			If strDimType.StartsWith("E")
				retValue = "E#None"
			End If	
		End If

Return retValue
	Catch ex As Exception
		Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
	End Try
End Function
&nbsp;
&nbsp;
I'll try to create a follow-up to the previous post, hopefully by this weekend.

Forum Discussion

Selecting your own member-filter in CV

4 Replies

Related Content

Member filter in Cube View

Create Parameters for Member Filters...where to start?

Formatting of multiple Member Filters in CubeView

Where clause in Member Filter Builder

Member Filter Functions in Finance BR