Hi Everyone,
I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward
@Sai_Bharadwaj_Venati
Let me give you some hints how to understand Optimizer:
In Revenue and Cost you are using a non-linear function. It means that both multipliers are variables. Optimizer works with the multiplication of one variable to any line item which does not lead to another variable. So if you have two variables (A and B) you can multiply them neither directly (A*B) nor indirectly (A*x, where x = B). You can use only A+B. A-B is also ok, because it is A + (-1)*B.
This means you should start from a simpler case where Salling Price and Cost Price are constants (not included in variables of the optimizer). (SP cons/CP cons should be removed from optimizer settings too)
Net Income objective should be Maximize otherwise the values will stay zero (now it is Minimize)
Obj cons and Obj Input are not very obvious. Could you explain what you are trying to check with it?
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Hello there, we are using AnaplanXL to pull data from 3 different sources into one Excel file. Two of them are Azure SQL data bases and the third is Anaplan itself. Whenever the Excel is opened 3 pop up windows to log in to each data base appear. Until they appear and everything is entered or clicked already 2 minutes are…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
