Hello, Is there a way we can retrieve the module IDs & line item IDs? It'd be really helpful in understanding the MAPS report instead of having to copy paste & check the id for each line item. Thanks!
I learnt something new today looking into this. I was originally going to respond with 'use REST API with Postman or equivalent' but found a post from @alexpavel where you can just drop a URL in your browser (assuming you're already authenticated) and that's it (nice one Alex, saves me time too).
@devrathahuja, try this: https://us1a.app.anaplan.com/2/0/models/MODEL_ID/lineItems?includeAll=true
Hey @luke_e , Thanks for sharing. That's pretty neat! :) Yes, would be nice if we can also get the line item ids a similar way.
Hi @devrathahuja I think @AjayM has called it out, but you should be able to get the line items using the URL.
If done correctly, you'll get an output that looks like the below, repeated for each line item. The 'id' field is the one you'd be after with the 'moduleID' unsurprisingly being the id for the module, but you'd need to transform this a bit in excel to make it look more presentable.
As you can probably tell, it contains the various attributes relating to a line item which maps back to the.. MAPS report.
Thanks @AjayM , that helps! :)
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β¦
