Three Quick Tips for a Fast BI 360 Report

Are you ever frustrated by the length of time it takes for your BI 360 report to run in Excel? We have gathered a few quick tips for you to follow to reduce your report run time.

There are several factors that could lead to a long a report run time such as number of sheets, use of functions versus period calculations, number of groupings or filters, or even the amount of data being brought into your BI 360 report. To avoid waiting for many minutes or even hours, try a few of these steps first to see if your report run time will improve.

Here are the three fixes we have found to be the most useful:

  1. Get rid of those unnecessary OSR formulas!

If you’re using mathematical functions in your report, be sure to use the native version of that function instead of the OSR version. This helps reduce the runtime by using the standard Excel version of the equation.

Try this: BI 360 report tips
Instead of this: BI 360 report tips
  1. Try to use fewer groupings on your rows. It can be an easy habit to get into, but the more you include, the longer your report runs. Try to limit the number of groupings to only one or two per section of your financial statement. Having two or three groupings on each Account row can drastically slow down your report.
    BI 360 Report Tips
  2. Sort and filter on your dimensions and not your attributes.The indexing in your Data Warehouse and SSIS typically looks at the dimension code and not your attributes.
    BI 360 Report Tips

Other alternatives to these steps may include more filter changes or purchasing additional features from Solver’s BI360 such as the Data Warehouse or the Publisher.

The Data Warehouse allows you to manipulate your data in a way that will improve data organization and report efficiency. The Publisher tool is useful when you know your report is going to take awhile, but you do not want to change any of your features or customizations within your Report Designer. With Publisher, you simply set your report to run at night before you leave the office and Publisher will execute and distribute your reports so that an email will show up in your inbox in the morning with your report ready.

As I stated earlier, there are many potential causes to a long report run-time outside of these three, but this is a great start to narrowing down the causes!

For more tips about reporting in BI 360, check out this Solver PDF about best practices: Have other questions? Sikich is ready to help. Let’s chat.

By |2019-03-27T10:06:27+00:00March 27th, 2019|Power BI, Technology, Tips & Tricks|0 Comments

About the Author:

Elaine Foley
Elaine Foley is an functional Dynamics GP consultant in the firm’s technology group. She joined Sikich in June of 2018 for her first job after college. Elaine is from the Chicago area and works in the St. Louis office, supporting clients with financial and technical assistance as well as demonstrating reporting tools for Great Plains.
This material has been prepared for general informational purposes only and is not intended to be relied upon as accounting, tax, or other professional advice. Please refer to your advisors for specific advice.

Privacy Information

We use cookies to personalize the website for you and to analyze the use of our website. Click 'Privacy Options' to configure how we can interact with you and your device or computer.

Privacy policy | Close
private equity services construction accountants Agriculture Services Construction Services Non-Profit Services Government Services