The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Davy's avatar
Davy
Contributor
3 years ago
Solved

view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?

How do I view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule? I think I can run this statement: Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov....
cubeview
XFBR
  • ChristianW's avatar
    ChristianW
    3 years ago

    It is an UD8 member formula and it has to be used together with a text view member like annotation:

     

     

    The member formula might look like this:

    ' Test if the cell is a text-based dataCell.
If api.View.IsAnnotationType() Then
	'Has the cell a cell text or an attachement?
	If Not api.Data.HasDataAttachments("O#Forms:V#Periodic:Ud8#None") Then
		'Retrieves the cells to test		
		Dim amount As DataCell = api.Data.GetDataCell("O#Top:V#Periodic:UD8#None")
		Dim budget As DataCell = api.Data.GetDataCell("O#Top:V#Periodic:UD8#None:S#BudgetV2")
		'Calculate the variance percent
		Dim variance As Decimal = (amount.CellAmount - budget.CellAmount  ) / budget.CellAmount

		'Is there a negative variance?
		If variance < 0 Then
			Return "<== Explantion Required"
		Else 
			Return Nothing
		End If
	Else
		Return Nothing		
	End If
End If

Return Nothing

     

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
3 years ago

The XFBR function in a cubeview, will be resolved before the system retrieves the datacells, so there is no way for the rule to get the POV of a cell (because it doesn't exist yet).

The problem are dynamic queries like A#IS.descendants, when the xfbr is executed, the query isn't resolved yet.

There are several ways to work around this limitation, can you help us to understand, what you try to achieve?

 

Davy's avatar
Davy
Contributor
3 years ago

Wow!! I have no idea what the differences are between XFBR vs using formula and financial business rules. Obviously, you are some big shot developer at 1S. Or are you a consultant? If yes, which company do you work for?

I was studying some XFBR code written over 5 years ago, that I inherited.  I suspected there was some issue with XFBR not being able to read the cell's POV.  I think what you wrote is true- which means that case, 1S consultants' use of XFBR to do conditional formatting is flawed.
I guess my first question is - why would anyone use XFBR, except to process something before retrieving datacells!!