Formula to return Connection details...

Question

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 · Answer

@Fiorentino check out this video to see if the formula works for you.

Fiorentino · Answer

https://community.anaplan.com/discussion/comment/173668#Comment_173668

Unfortunately, my information doesn't display like that.

My server shows as null. Database shows as a key HEX values and Cube shows as a 12 digit number.

I would like to have the information in the Connection Properties show, in particular the data in the Value fields, highlighted in the attached image.

ElizabethS · Answer

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