UD8 Dynamic Calc - Retrieve Data From Another Application

[NickKroppe]

Hello, 

I wanted to post this here since this came up at the Wave Conference in Vegas last week. Below is a snippet you can leverage to pull data from another application via a UD8 dynamic calc. This approach uses the CreateSessionInfoForAnotherApp BRApi to create a session in another application with the current user's credentials which ultimately enables you to execute any BRApi function (such as the GetDataCellUsingMemberScript BRApi) against another application in the same environment. This technique can be especially useful when looking to report on data that lives in two applications (in the same environment) in cube views and quick views.

'define the other application name you wish to connect to - this must be an app that lives within the same environment
'the user must also have access to the application to authenticate to it
Dim otherAppName As String = "SomeOtherApp"
'create the session info to the other app and store it globally in memory
Dim otherAppSeshInfo As SessionInfo = globals.GetObject("OtherAppSeshInfo")
If (otherAppSeshInfo Is Nothing) Then
	otherAppSeshInfo = BRApi.Security.Authorization.CreateSessionInfoForAnotherApp(si, otherAppName, OpenAppResult.Success)
	globals.SetObject("OtherAppSeshInfo", otherAppSeshInfo)
End If
'get the POV intersection from the CV and swap out the UD8 none member with the name of this UD8 reporting member
Dim povMemberScript As String = api.Data.CreateMemberScriptBuilder(True, True, True, True).GetMemberScript().Replace("U8#GetDataFromAnotherApp", "U8#None")
'return the POV cell amount from the other application
Return BRApi.Finance.Data.GetDataCellUsingMemberScript(otherAppSeshInfo, api.Pov.Cube.Name, povMemberScript).DataCellEx.DataCell.CellAmount

Regards,

Nick Kroppe

Advanced Application Solutions

OneStream Software

[psc]

Hi Nick,

Thanks for this! Is there a way to then be able to export to a csv? I haven't seen a way to export a dynamic calc?

[JasonKarber]

Hey Nick,  I did this in an app and it worked like a charm.  Was great to pop two columns in a cubeview, create a variance column and filter down to mismatches with suppression on the variance only.

pscrisp -I suspect that you could use the rule concept for a stored calculation if you need a repeatable process for an export.  That said if it is one-off or at least occasional then the cubeview I referenced above easily exports to excel which could be saved as a csv.

[wnindl]

Thank you Nick. This is a time and life saver.