The Sage Intelligence Report Scheduling function allows the automated, interval-specified export and creation of report files with the assistance of the standard Windows Scheduler. This functionality is ideal when specific scheduled reports need to be either available on a specific
Are you looking for an alternative to the Sum function that can also ignore hidden values? Then look no further than the Subtotal function. The Subtotal is a versatile function that: Can be used for a wide range of numerical
Ever tried to create an Excel graph from scratch? You can actually add your own Legend Entries (Series) and Horizontal (Category) Axis Labels. The location of the data should not hinder one from creating a graph. In the example below
PRE-REQUISITES Prior to developing a template it is recommend that a comprehensive requirement document be completed in addition to the following: Completion of Connector, Advanced & Basic Intelligence Training. Completion of the Excel on Steroids training. Adequate sample data. SQL
When you have many different PivotTables in one report, such as a Business Intelligence (BI) report that you are working with, it is likely that you will want to apply the same filter to some or all of those PivotTables.
Ensuring the data that users enter into a worksheet conforms to certain standards is difficult, if you have no way of enforcing the rule. With Data Validation you can: Provide users with a drop down list of choices (so they
You can copy and paste a report, at any stage, in the Report Manager. These functions are useful in Sage Intelligence Reporting because all the Master reports are locked and you need to make a copy of these master reports. Use
Vertical Lookup is one of the commonly used MS Excel functions. But it has limitations in that the main search criterion needs to be in the first column. However by using a combination of MATCH and INDEX, you can return
The 7 member strong Sage Alchemex team just returned from the 2012 Sage Summit conference in Nashville, Tennessee, where we presented over 32 Sage Intelligence related sessions from boot camps, to hands on labs, round tables, training sessions and presentations.
Sage Summit never fails to deliver for the Sage Intelligence team and I can only reflect with great pride on our team based on the consistently positive feedback we received at Nashville. The greatest part of the annual get together