The latest release of BI360 is loaded with lots of new features and enhancements. You talked and we listened.  BI360 3.5 is setting the bar with advanced reporting from Excel.

Take Control of Your Data

Many Accounting / ERP systems allow custom tables and attribute fields.  Prior to v3.5, these custom fields and tables could only be accessed using our full Meta Data Integration application.  Now, the power to control your integrations is available for everyone within the same Administrative application you are already familiar with. All changes made to the integrations are instantly available throughout the BI360 suite.  The customizations are self-contained so your changes are never affected by version upgrades.

Modifying your integration has never been easier.  You can pick your integration to edit Modules, Dimensions, and Factsets (Transaction tables). Change labels, hide fields, make joins from fact tables to custom fields as well as a host of other extremely powerful options to control what you see throughout the BI360 suite.

Design Your Own Drill-To Logic

With the new Drill-To feature, you have control to design drill-downs the way you like them.  You can define the transaction table to drill to, as well as the fields visible when drilling into the transactions.  The below screenshot is an example from the Microsoft Dynamics AX 2012 integration.

Planning Ribbon Update

Not only have we added many new features to Planning, but we also have also reorganized the Ribbon to improve the users experience when working within the BI360 Planning application.

Planning Assignments Redesign

The Planning Assignments menu has been updated and reorganized.  End users are presented with an updated Assignment experience organized by three categories of Assignments (Upcoming, Active, and Ended).  In addition Assignment Details, start and end dates, as well as other important status information is now clearly visible.

More Dimensions = More Freedom

In version 3.5 of the Data Warehouse, all predefined dimensions are now conforming.  This means that every dimension can be used in every fact table (Module).  So for instance, in the past, the built-in Employee dimension was only available within the Payroll module.  In order to see Employees across modules, you needed to create a user-defined dimension.  Now in v3.5, the Employee dimension can be added to all pre-defined and user defined modules.  Additionally, Administrators can add up to 40 user defined dimensions that can also be used across all modules.  Similar to v3.0, an unlimited number of attributes for both dimensions and fact tables is possible.  The beauty is that the changes are instantly visible across the entire BI360 suite.  The updated Module Schema menu (below) now makes it incredible easy to configure the warehouse structure, all in a user interface designed for the business power user.

Upgrade to BI360 Version 3.5 Today!

Read the v3.5 Release Notes to find out more about all the amazing new features and enhancements available today.

The business intelligence (BI) software market can be tough to navigate. Not only do organizations have to sort through hundreds of available products, they also have to make sense of the jargon, trends and other technical aspects of BI tools (e.g. “OLAP” or “in-memory processing”).
Getting a handle on these concepts early in your research process is critical. You’ll want to be literate when you discuss your next purchase with your management team, IT staff and eventually sales representatives.
There are several online resources to help you get up to speed, such as the Solver blog and Software Advice. Software Advice is a website that reviews and compares business intelligence software vendors. They recently put together an introduction guide to three BI tools: data warehouses, ETL tools and OLAP tools.
In their post, “Business Intelligence 101 | A Beginner’s Guide to BI Software,” they explain the function that each tool performs, and why and when companies need to use them. They also discuss four prominent trends currently playing out in the market: predictive analytics, SaaS, “Big Data” and in-memory processing. Here’s an excerpt from their post about data warehouses:
Online analytical processing (OLAP) is another key process and technology found in almost all data warehouse environments and business intelligence systems. But while the data warehouse and ETL tools support “back end” processes, OLAP tools support the presentation layer or “front end” processes such as querying, analysis and reporting. OLAP tools provide the impressive tables, charts and visualizations that make BI exciting!

But OLAP isn’t just about good looks; it’s got some serious smarts under the hood. OLAP allows users to perform sophisticated, multidimensional analysis. In other words, it allows you to analyze more than one dimension of data at a time. For example, you could analyze how many yellow t-shirts were sold during the month of July in Texas and compare it against other t-shirt sales during the same month.
In addition, understanding customer buying habits and buying preferences are the keys to having the right products at the right time. Tools like BI360 put sales information at your fingers tips. You can create powerful reports giving you access to critical business trends, thereby providing you the intelligence to make the right decision.

Today’s accounting departments want financial report writers that require a minimal amount of report maintenance when there are changes in the underlying accounting system, such as new account numbers. Furthermore, they always want to be able to rest assured that their financial statements include any segment or dimension updates done in the general ledger, thus assuring that their financial statements are correct.
You can use BI360‘s Expanding Group concept to automatically list accounts based on ranges. This will capture any new account within the range that has been created in the general ledger. The use of expanding groups also has additional benefits such as faster report design process and shorter report execution time.
Expanding groups are groupings of one or more columns or rows within a BI360 Excel spreadsheet that repeat for a specified range of values. For example, just like you can have account ranges dynamically listing accounts in the report rows, you can have a column in your spreadsheet that repeats for each month for the current year.  This saves you time and effort over having to define each of the 12 columns one at a time.  These groups are easy to set up — just a matter of checking the ‘expanding’ option in the BI360 report definition when adding data fields to columns or rows of your spreadsheet.

LOS ANGELES, California, January 5, 2012 – Solver, Inc., a global leader in Business Intelligence for Microsoft Dynamics AX, GP, NAV, SL and other enterprise resource planning (ERP) systems, today announced record revenues and customer base growth for 2011.

“2011 was a fantastic year for Solver. Our BI360 suite for Excel-based reporting, budgeting, dashboards and data warehousing grew the customer base close to 100% across North America, Europe, Middle East and Africa. We also got our first BI360 customers in the Asia Pacific region, where we are opening a new local office this month” said Nils Rasmussen, CEO at Solver.

Solver’s BI360 suite represents a new generation of Business Intelligence tools that can be managed by the finance team as well as operational managers, without the need for IT skills. Live reporting directly on the ERP system’s database offers immediate ROI as users can start developing reports from the minute that BI360 has been installed. Drill down from financial statements to detail, such as invoices and purchase orders, gives department heads the ultimate tool to answer their questions without ever having to ask accounting staff to run reports or to do lookups in the ERP system.

“Customers using ERP systems like Microsoft Dynamics AX, GP, SL, NAV, Sage and Epicor have long been looking for replacement tools for legacy reporting and budgeting solutions like FRx and Forecaster, and BI360 is becoming a natural upgrade path due to the deep, live ERP integration as well as the familiar Microsoft Excel user interface,” said Mike Applegate, VP of Development at Solver. “Our resellers and customers are also in for a big treat in 2012 as we roll out version 3.5 this month, and then, version 4.0 is coming in June, with very exciting new features and capabilities.”

About Solver

Solver, provides BI360, the leading Business Intelligence suite for Microsoft Dynamics AX, GP, NAV, SL, Sage MAS 500 and X3, Epicor Prophet21, and other ERP systems. Solver is a Microsoft Gold ISV Partner and the winner of the Microsoft BI Partner of Year Award. BI360 is sold through a world-wide network of resellers and is ideal for companies looking to find a user friendly, yet highly functional Reporting, Budgeting, Dashboard and Data Warehouse solution to give them deep insight and actionable information across all facets of their organization.

For any questions, visit Solver’s website or contact Solver at