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?
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
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.
@Fiorentino check out this video to see if the formula works for you.
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
I have complated my Anaplan Level 2 Certification. Can anybody assist me to get a employment opportunity to get access for Level 3.
I have a list call lease ID that has a top level called All Lease ID. I do not want the top level to be seen in my selection. What can i do ?