Is it possible to pass a parameter to a UD8 dynamic calc member?

[MarkBird]

Hi all

I currently have a UD8 member to do a simple variance to actuals formula, but I was wondering if it is possible pass parameters to the UD8 member formula that this could be more dynamic?

My current code looks something like this:

Try
	'Declare base and comparison scenario variables
	Dim currentScenario As String = api.Pov.Scenario.Name
	Dim comparativeScenario As String = "Actual"
	
	'Define pov filters
	Dim currentFilter As String = "S#" & currentScenario & ":U8#None"
	Dim comparisonFiler As String = "S#" & comparativeScenario & ":U8#None"

	Return api.Data.GetDataCell("BWDiff("& currentFilter & "," & comparisonFiler & ")")
	
Catch ex As Exception
	Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try

However, I'm trying to see if there is a solution where I could have the following:

Dim comparativeScenario As String = |!Comparative_Scenario_Parameter!|

Thanks,

Mark

[Omkareshwar]

Hi Mark, 

You can read literal value parameters inside a dynamic calc.

I will suggest using Difference Between Columns in the Cube view itself rather than having a parameter inside a dynamic calc. 

In the above example I am using Difference Between Columns CVC to get the difference between the scenarios. The Column names are self-explanatory you can setup your cube view like shown above. This approach is dynamic and works similarly just like a dynamic calc but will be easier to maintain. In your case you can replace Difference Between Columns CVC with Column Better/Worse CVC [GetDataCell(BWDiff(CVC(Col1), CVC(Col2))):Name(BetterWorse Difference)] rest everything will remain the same.

Thanks, Omkareshwar

Archetype Consulting

[MarkBird]

Hi Omkareshwar,

Thanks for the response.

Literal parameters won't work as I'm looking to try pass user prompt parameters to the UD8 calc.

And the reason I don't want to do the formula as a cube view formula, is because I use the result to generate status indicators like the ones below:

The indicator is determined using a business rule based on the outcome of the variance. I would like to have a single formula for both the variance column and the status indicator to ensure that they are always consistent.

The only way that would work is if I was able to pass the result of a cube view calc to a business rule, which I don't think is possible.

If the UD8 route isn't possible, then I'll just create a business rule instead. 

Regards,

Mark