At the start of this year, BI360 became Solver.
All of the same content and features under a new name.
Use the Excel-based reporting engine to design custom reports combined with the power of Excel. The best part? No code needed, everything is provided to you via a drag-and-drop interface. Connect to your data directly or to the built-in data warehouse.
Effortlessly create and manage budgeting, forecasting, and what-if scenarios. Store your data back into the Data Warehouse and report on it alongside other scenarios and your actuals.
Power BI connects natively to the Solver Data Warehouse and extends the platform with a best-in-class data visualization solution.
The Solver suite includes a native Data Warehouse with a pre-defined format optimized for reporting and with numerous additional insights to your users and also protect your data from prying eyes.
Solver Reporting makes it easier than ever before to design reports and interact with your data. Design virtually any type of report imaginable and finally get the real insights into your data that you’ve been looking for.
Multiple Ways to Report!
Clicks, Not Code
Solver’s planning module expands your reporting capabilities, and allows your users to store input data, such as budgets, back into the data warehouse.
Getting an overview of your data is quick and easy with Solver’s Power BI Integration. Using Power BI’s intuitive, drag-and-drop simplicity, you can customize your data and create dashboards on the fly with pre-defined widgets and modules.
Data Modeling made Simple
Drag, Drop, Done
Insight, not Hindsight
A data warehouse, or DW, is a database in which we store data from multiple solutions side-by-side. In addition, all data entering the warehouse is transformed into a format that is optimized for reporting. For more detail on what a data warehouse is and what it allows us to do, please check out [link to article] this article.
BI360 simply rebranded the product suite to match the company name. BI360 is now Solver, and has all of the same features and value, just under a new name.
A fact is a value or measurement that represents a meaningful data point regarding a specific activity within the organization. Facts can include individual transactions such as sales or payments, or aggregated data such as account balances or inventory stock levels. Typically, your transactional data or “what happened” is answered by facts.
In Solver, module and fact are interchangeable terminology. See the above.
Dimension tables store lists of objects or things like customer, natural GL account, projects, etc. Often, instead of storing all of the details of a transaction with a customer in a single table, the customer’s details are kept in a separate table. When a transaction occurs with that customer, the transactional or fact data simply just notes down for which customer that transaction occurred instead of entering all of their data again.
Yes, Solver allows dimension tables to be shared across multiple fact tables
Solver uses an API and a Power BI connector to extend your data warehouse and bring your data to Power BI reports and dashboards seamlessly. See more here (link to the dashboard detail section of this page)
No, Solver’s data warehouse has a pre-defined data format and if you are connecting to one of the many systems that have native integrations, this will be done for you. If not, it’s simple to just add new fields to your fact and dimension tables.
Absolutely! The Solver data warehouse can be extended to encompass data from many other sources. The best part is that all of the data in your data warehouse can be reported on as if it were from one system.
Currently both! Solver v5 is primarily geared towards being a cloud solution but does offer an on-premise installation for those who need it. We don’t recommend it unless you have a good reason though!
If you use Microsoft Dynamics GP or NAV then yes! Solver has a new hybrid-cloud reporting solution that allows it to interface with your on-premise GP or NAV installation.