Formula to return Connection details...

Fiorentino

I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it.

Is there an XL3 formula to return this value?

ElizabethS

Hi -

If you are using a grid, you can use the Grid title to display the connection. Here is a link to the Anapedia page for more details.

If you are connecting to Anaplan as a data source, this is what will be returned:
{server} - Tenant\Workspace
{database} - Model Name
{cube} - Module Name

You can even mix and match the available place holders in the same Title or even layer in other text, such as:

Module Name: {cube} from Model: {database}

which will display as:

Module Name: DATA01 P&L Actual & Budget from Model: L1 Dev Model