This function retrieves information about a connection
Syntax
XL3ConnInfo( ConnectionID, ItemName, ShowCaption )
Parameters
| Parameter | Description |
| ConnectionId | Returns the number of connections to retrieve information. |
| ItemName | The name of the report property to retrieve in text format. Valid values are:
|
| ShowCaption | FALSE returns the ID (default). TRUE returns the caption |
Example
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
