Forum Discussion

BenvanBergen's avatar
BenvanBergen
Contributor
2 years ago

Aggregation Weight Display in Cube View

Hello, How can I see the signage from aggregation weights. For example I have these 2 account groups in a hierarchy: PL44000000 has aggregation weight 1 PL43700000 has aggregation weight...
Cube View
JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

There is probably an approach using a UD8 member, but if the child has multiple parents it becomes difficult to pick the right one.

Another approach is to have a custom GetDataCell function, which can accept parameters using a technique like the one described here. You will have to hardcode the parent, but it will work.

' in a Finance business rule
Case Is = FinanceFunctionType.DataCell
	Dim callELements As List(Of String) = StringHelper.SplitString( _
		args.DataCellArgs.FunctionName, "~", StageConstants.ParserDefaults.DefaultQuoteCharacter)
	If callELements(0).XFEqualsIgnoreCase("GetWeight") Then
		' parse the string passed in
		Dim params As New NameValueFormatBuilder(callElements(1))
		' now retrieve the parameter value
		Dim parentName As String = params.NameValuePairs("parent")
		' look up weight
		Dim weight As Decimal = api.Account.GetAggregationWeight( _
			api.Members.GetMemberId(dimtype.Account.Id, parentName), _
			api.Pov.Account.MemberId)
		
		Return weight
	End If

With this dimension:

In the Cube View: