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

MarkBird's avatar
MarkBird
Contributor III
4 months ago
Solved

XFGet formula to retrieve application name

Hi

Is there and XFGet type of formula that can be used to retrieve the name of the application that you are currently logged into?

Thanks,

Mark

Excel Add In
  • MarkBird's avatar
    MarkBird
    4 months ago

    I have just managed to resolve this by creating a technical account called ApplicationName. The account is set to DynamicCalc.

     

     

     

     

     

     

     

    The formula is as follows:

    'Returns the name of an application
Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId)

If viewMember.IsAnnotationType Then
	'Only return the app name if this is a text-based dataCell.
	Return api.SI.AppName
Else
	Return 0
End If

    And then I used XFGetCell formula to retrieve the application.

    =XFGetCellUsingScript(TRUE, "Reporting", "A#ApplicationName:V#Annotation", "", "")

    A little bit long winded, but it does the trick. Not sure if anyone has a better idea.

    Mark

1 Reply

  • MarkBird's avatar
    MarkBird
    Contributor III
    4 months ago

    I have just managed to resolve this by creating a technical account called ApplicationName. The account is set to DynamicCalc.

     

     

     

     

     

     

     

    The formula is as follows:

    'Returns the name of an application
Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId)

If viewMember.IsAnnotationType Then
	'Only return the app name if this is a text-based dataCell.
	Return api.SI.AppName
Else
	Return 0
End If

    And then I used XFGetCell formula to retrieve the application.

    =XFGetCellUsingScript(TRUE, "Reporting", "A#ApplicationName:V#Annotation", "", "")

    A little bit long winded, but it does the trick. Not sure if anyone has a better idea.

    Mark