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.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.β¦
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the nodeβ¦
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create aβ¦
