|
What
is XL Reporter?
iLytix XL Reporter for
Reporting
Because the
product uses Microsoft Excel as an integral part of
the user-interface, formatting, calculations, etc.
immediately makes sense to end-users, thus supporting
wide-spread adoption of the solution in a company.
With drag-and-drop report design, and the power of
Microsoft Excel as your presentation tool, you can
write powerful reports on live data across the modules
of both the Microsoft Dynamics GP (Formerly Great Plains) and Microsoft Dynamics SL (Formerly Solomon) applications without first storing the data in OLAP cubes or in other databases.
iLytix XL Reporter for
Budgeting
iLytix XL Reporter is also
a budgeting software. Using direct write-back
functionality, you can build your own Microsoft
Excel-based budget forms to store the data directly in
the budget-table of the both the Microsoft Dynamics GP (Formerly Great Plains) and
Microsoft Dynamics SL (Formerly Solomon) systems. This provides your
company with one single reporting and budgeting
solution that is easy to roll-out to your users
because it is all completely Excel-based.
Key Features of XL
Reporter?
Dashboards
The term “Dashboard”
(best known as the instrument panel in a car, boat,
or aircraft) was first used in connection with
reporting in the late 1990’s to depict an
automobile-like user interface where different dials
and gauges represented various indicators of an
organizations’ financial or operational situation.
Since then, the term has grown considerably in
popularity and it has been adopted across
corporations, educational institutions and
government organizations. No longer does a dashboard
refer to just reports with dials and gauges, and the
term is widely used to depict any type of summarized
or graphical report. XL Reporter is an
excellent tool for creation of all types of
dashboards including:
Key Performance
Indicators (KPI's)
Scorecards
Business
Performance Management (BPM)
Reporting
iLytix XL Reporter is
fully and completely integrated with Microsoft Dynamics GP (Formerly Great Plains)
and Microsoft Dynamics SL (Formerly Solomon).
It reports on live
data, which means that the data are extracted
directly from the Microsoft Dynamics GP (Formerly Great Plains) and Microsoft Dynamics SL (Formerly Solomon) databases without
staging data in OLAP cubes or in a data-warehouse.
Includes an easy 'drag
& drop'/'slice & dice' tool that allows you to
query data live and to make reports in seconds,
without any prior knowledge of the database
structure in Microsoft Dynamics GP (Formerly Great Plains) or Microsoft Dynamics SL (Formerly Solomon).
Allows data to be
extracted from across all the main modules in
either the Microsoft Dynamics GP (Formerly Great Plains) or Microsoft Dynamics SL (Formerly Solomon) systems into the same report, for instance to
create dashboards and key figures reports.
"Hides" the technical
names and table structures of the Microsoft Dynamics GP (Formerly Great Plains) and
Microsoft Dynamics SL (Formerly Solomon) system
databases so that the users do not need to have
this knowledge in order to write reports (iLytix
XL Reporter has a Meta Data concept that maps all
the technical names and links of the Microsoft Dynamics GP (Formerly Great Plains)
and Microsoft Dynamics SL (Formerly Solomon) system
databases to the ERP system user interface).
Uses Microsoft® Excel
as the user interface both to create report
definitions and to present the finished reports.
Supports live
drill-down to posting level from the reports.
Offers advanced
reporting features like dynamic expanding groups
in both rows and columns so that the users do not
have to hardcode for instance 'Accounts' in rows
or 'Periods' in columns.
The combination of
iLytix XL Reporter™ and Microsoft® Excel makes
'almost anything' possible for the user who can
create all kinds of reports, from standard sales
and balance reports to complex ad-hoc reports with
key figures and graphics.
Budgeting
Microsoft® Excel for
data entry, and your Microsoft Dynamics GP (Formerly Great Plains) and Microsoft Dynamics SL (Formerly Solomon) databases for storage.
Allows you to freely
build your own budget forms.
You can make budget
forms into compound packages of budgets.
Allows for automatic
distribution of budget packages through email. The
receiver only needs Microsoft® Excel.
Registered budget
figures are returned through email and saved
directly in the Microsoft Dynamics GP (Formerly Great Plains) and Microsoft Dynamics SL (Formerly Solomon) databases.
Supports write-back
directly into the budgeting table in the Microsoft Dynamics GP (Formerly Great Plains) and Microsoft Dynamics SL (Formerly Solomon)
systems from user-defined forms created in
Microsoft® Excel.
Report Administration and Access
Management
Handling of report
definitions and finished reports.
Reports can be
compound into report books.
Offers distribution of
reports and books through email.
Supports advanced and
automatic scheduling, execution and distribution
(to library, disk, or email) of reports collected
in packages.
Offers advanced access
management so that people with different access
levels can run the same report, but only get the
data that they have permission to see (for
instance, a limitation by Department).
|
