Skip to main content
J
jesvam
August 9, 2023
Solved

Accessing predefined substitution variables in Business Rules

  • August 9, 2023
  • 3 replies
  • 0 views

Hi, I can't seem to find a method in the api that accepts a substitutionvariable object and returns the string value of that substitution variable. Or just get a dictionary of all predefined substitution variables and their values. 

Is this or something similar available? 

Best answer by JackLacava

Do it in an XFBR, there you have everything you need in args.SubstVarSourceInfo.

3 replies

C
ChristianW
August 9, 2023

If you use the dashboard extender business rule, you will find the information here:

ChristianW_0-1691585012722.png

 

J
jesvamAuthor
August 9, 2023

Thanks, but I don't believe this is for the predefined ones.

J
JackLacavaAnswer
August 10, 2023

Do it in an XFBR, there you have everything you need in args.SubstVarSourceInfo.

J
jesvamAuthor
August 10, 2023

Thank you Jack, that is super useful! I also managed to find what I wanted based on that object you provided in the api details. Pasting a snippet below for anyone reading. 

Unfortunately it didn't contain what I was searching for now. I was hoping a dynamic calc could somehow pull cube view substitution variables from the cube view it is calculated in, but seems that it is not the case.

Dim instance As New SubstVarSourceInfoFactory
Dim dbConnFW As DbConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si)
Dim dbConnAppOrFW As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
Dim isSystemLevel As Boolean = False
Dim value As SubstVarSourceInfo
value = instance.GetOrCreateSubstVarSourceInfo(dbConnFW, dbConnAppOrFW, isSystemLevel)
J
JackLacava
August 10, 2023

If you're doing a Dynamic Calc, what you could do is actually using a custom GetDataCell function. This way, you don't need to worry about resolving expansions yourself - you just pass the variables you need as arguments.

This is a woefully undocumented corner of the platform, but it's actually quite cool. In a Finance BR (called "MyFinanceBR" in this case), use the relevant FinanceFunctionType block:

 

Case Is = FinanceFunctionType.DataCell
	If args.DataCellArgs.FunctionName.XFEqualsIgnoreCase("MyFunction") Then
		api.LogMessage(args.DataCellArgs.NameValuePairs.Keys(0))
		api.LogMessage(args.DataCellArgs.NameValuePairs.Values(0))
		Return 1  
	End If

 

Then in your CubeView, use the expanded syntax (sadly it doesn't seem to work with the condensed one)

JackLacava_1-1691671963343.png

Result:

JackLacava_2-1691672028509.png

note how I had to put square brackets around my variable, that's because otherwise spaces and special chars will wreak havoc on the expansion.

In terms of performance, I *think* this strategy might be a bit faster than opening db connections in XFBRs, but I could be wildly wrong.

J
jesvamAuthor
August 14, 2023

Thanks! But with a data cell BR you wouldn't be able to return a text value right, it only returns numeric values?

I was hoping to dynamically determine the text value that the cell would return based on the cvname for example. 

Terms & ConditionsAccessibility statement