The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on?
Hi, there are standard Google Sheets limits for worksheets applicable. You're limited to:
There's no limit to the number of rows you can have in a worksheet. You cannot create a connection to a module that contains a dimension with more than 1 million items.
Note: A connection between Anaplan and a new worksheet uses at least 26,000 cells from the 1 million in the worksheet. This is to protect any custom data you enter into cells outside the data you retrieve from Anaplan.
For more details refer the following Link: https://help.anaplan.com/anaplan-add-on-for-google-sheets-12e56d54-c37e-4791-9771-1a6bbee8e4d5
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
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 all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…