Business Intelligence

23
Sep

Analyst Report: ZAP Strengthens it’s Data Management Proposition with Data Hub

          This IDC Market Note focuses on ZAP’s product evolution into a provider of data management and data warehouse automation solutions and how this move sets the stage for new and expanded OEM relationships. ZAP has briefed IDC to outline how the company is strengthening its product road map and overall positioning in the wider data

Read more

10
Sep

Business data integration: Why it needs to be addressed, and how to best tackle it

The ability to integrate your data from multiple sources allows for business-wide reporting and enhances BI insight, but what happens when your data isn’t integrated? View the ZAP infographic below to understand: The current issues facing organisations with regards to how they integrate their data The numerous data sources which require integration The hurdles which can be overcome when your

Read more

6
Jul

Excel data manipulation using array formulas

Whether we like it or not, there’s always a process, a form, or a report that requires a little bit of manipulation in Excel. We just need to apply one simple operation to use the result elsewhere. But there’s no way to easily do that manually. Often, the issue comes from the source data not having the same number of

Read more

6
Jul

6 best practices when writing reports

We recommend the following six best practices when writing your reports: Use cell references to enter data into formulas. Using cell references in formulas allows the formula to update when the data is changed at a later date, without having to manually edit each formula. This method makes modifying and maintaining your worksheet easier. Use account ranges in your reports to ensure new accounts

Read more

6
Jul

How Licenses are Assigned within Sage Intelligence Reporting

Sage Intelligence Reporting uses a Workstation Licensing model. Almost every Sage solution comes with at least one Report Manager license. That license, and additional licenses you buy, are managed through the License Manager module. The License Manager is a module that is available to all Sage Intelligence users. It allows you to see which users and workstations are consuming Report Manager and Report Viewer licenses and their module configuration.

Read more

6
Jun

Using expressions in Sage Intelligence Reporting

An expression in Sage Intelligence Reporting is a selection from the available fields of a data source, that either become columns in the Excel report or provide filtering assistance. Expressions reside in the Container within the Connector and can be modified or created. In the Connector, when you click on a Container, you will see the list of expressions –

Read more

26
May

How to convert a Sage 300 FR Report to Sage Intelligence

To get some of the legalities out the way, please note that this guide is provided ‘as is’ to assist with the conversion process and is not supported by Sage ERP Support as per Sage Support Coverage terms. This document is also not intended to serve as a guide to Sage 300 Financial Reporter or Sage IntelligenceReporting. You are required

Read more

21
Apr

Learn how to Schedule your Sage BI Reports automatically

Stop manually distributing your reports and start saving time by scheduling your reports to automatically distribute. In this tip, we’ll show you how to quickly set up your automatic report distribution with your existing Sage Intelligence Report Manager and your Windows Task Scheduler. This process is made up of 3 easy steps: 1. Decide where you’re going to save your report.

Read more

4
Jul

Analytics and Business Intelligence Webinar

Learn how data consolidation can advance your business In a digital economy, faster access to the right data is critical for success. Usually this requires organisations to transform – from viewing department-driven data in isolation, to having a single consolidated view of the business. One of the easiest ways to achieve this is by integrating business critical data systems. But

Read more