Solver’s High Performance Data Warehouse Software Tools In-Depth

​

The data warehouse’s most powerful features include:

​

Simple Configuration

​

There is no installation as the Solver Data Warehouse comes with your Solver cloud tenant. In other words, you can immediately  start configuration and data loading. Implement your new, high performance data warehouse in a few steps:

• Log into your new Solver cloud tenant

• Choose the number of years you want to open up in the time dimension

• If applicable: Set up currencies, rates and rate types

• Configure the Connector to your data source(s)

• Load your data

• Import or design reports, budgeting templates and, if applicable, Power BI dashboards

​

Solver ETL Automated Data Loading

​

Solver offers various ERP, CRM and generic connectors for load your data. Get trained or work together with a consultant to configure the connector(s) and aggregate data from all of your sources. By offering an integrated ETL tool in the Solver suite, you get automated data loading that eliminates typical manual steps. With the Solver Data Warehouse and ETL tool, you can perform automatic data transfers to keep your information accurate and current.

​

Financial and Operational Data Integration

​

Manage and analyze financial and operational data in one place. With your information on finances and operations in the same data warehouse, you can find trends and exceptions in performance for smarter business decisions. Solver works with a wide range of data sources and integrates with popular platforms such as:

• Acumatica

• Microsoft Dynamics (All Cloud & On-Premise ERP and CRM offerings)

• NetSuite

• Quickbooks Online

• Sage X3, 500, 300 and 100

• Sage Intacct

• SAP Business One and ByDesign

• Salesforce

• Solver Gateway for on-premise data sources

​

Benefits of a Extended Financial Planning and Analysis (xFP&A) Data Warehouse

Increased Efficiency

​

A robust xFP&A data warehouse streamlines the data storage and analysis processes through a single platform. Solver makes it easy to import and export data from multiple sources using simple actions. The data warehouse comes with many pre-configured modules to make reporting and analysis easier than ever. Custom modules will empower you to create datasets that matter to your business in a fraction of the time of a traditional spreadsheet.

​

Ease of Use

​

We implemented a variety of easy-to-use features in the Solver Data Warehouse. These easy-to-understand tools will enable you to become an information powerhouse:

• Seamless data transfer: Solver imports and exports data among applications smoothly to optimize your information storage.

• Data viewer: The Solver Data Explorer lets you display, filter and group information in the application without generating a report.

• Customizable attributes: Add and customize attributes for any of your dimensions for easier data organization and analysis.

• Dimension and Module Management: Add new dimensions and modules with a few button clicks.

​

Reporting and Dashboard Capabilities​

​

With Solver Data Warehouse, you can report on any number of dimensions and modules (data) in the same report. Using Solver’s powerful, cloud-connected Excel add-in, you can design virtually any type of report your organization needs and professionally format it. Your end users can run the reports or enter budget and forecast data directly in the Solver cloud portal using their web browser. Using Solver’s Power BI connector, you can easily move any of your data over to Power BI for professional dashboards in the world’s leading visualization tool.

​

Configuration Features

​

Transform your Solver Data Warehouse into a sophisticated tool for your business with user-friendly, menu-driven configuration options. Modify these aspects of the application and data warehouse:

• Accounts

• User-defined dimensions

• Time periods

• Trees

• Modules

• Data labels

• Business Rules

• Currency

​