This function retrieves information about a connection 

XL3ConnInfo( ConnectionID, ItemName, ShowCaption )

ParameterDescription
ConnectionIdReturns the number of connections to retrieve information.
ItemName

The name of the report property to retrieve in text format. Valid values are:

  • Server
  • Database
  • Cube
ShowCaptionFALSE returns the ID (default). TRUE returns the caption

To retrieve connection information for an Anaplan data source, use:

=XL3ConnInfo(2, "Database", TRUE) & " - " & XL3ConnInfo(2, "Cube", True)

Displays:

Unicorn Candy Demo - REV03 Margin Calculation