I need some help breaking down data that has been inserted into Anaplan via the excel add in, so that each component in the existing module can be listed as individual line items as in a data list. The attached photo lays out the dimensions I need, but I'd like to see it in a form that has the Cost center, Ledger code, date of the forecast item, and the amount each on an individual line, much like you would see in an excel sheet. I just want to have it essentially flattened so that I can use the 'raw' final state to be used as an export for other modules. Thanks in advance!
... View more
I too would like to have the ability to have multiple modules accessible from the same excel sheet. A few of our processes require information from different data pulls that are not attainable from the same source, whether it is specified through a module that attributes out a top level cost breaking out into sub levels manually or organized in such a way that the data is not accessible without multiple data reports (ex, revenue and cost of sale or expenses). When we want to combine information from those sources, each currently requires a single tab in Anaplan to refresh. For our income statement and balance sheet in excel, we need specific information from multiple accounting areas, as well as another set of pulls that are custom from multiple years of adjustments. Alternatively, profit centers encompass multiple products. We have multiple modules designated to break out those profit centers into those individual products, where it is not defined from the raw data. Doing so with Anaplan at this time requires 20+ sheets to refresh when inserting from excel. Being able to run those modules from the same sheet would both save file space and be more efficient when trying to incorporate formulas that link elsewhere.
... View more