Reporting
Create those beautiful reports everyone expects today, and do it with
direct live access to your data.
Callisto allows users to maximize the Excel experience by preserving the power of Excel they depend on
and love.
Retrieve live data into these reports then combine that live data with the Excel calculations that enable
your users to manipulate data providing information not stored in your database, like variance and
percentage variances.
Combine this with the native formatting available in Excel to produce powerful reports like the one
shown on the right.
|
Charts and Graphs - Callisto reports support all the Excel charts and
graphs. When combined with the dynamic expansions of Callisto it is easy to
create graphs that automatically change to reflect changes in the structure of
the Callisto application
without any maintenance to the Excel workbooks.
Just refresh the reports, and they automatically show exactly what is in
database.
In the report to the right, when new products are added, they automatically
appear in the report and the chart.
|
Trend Reports -
The rows or columns of your Callisto reports can be easily defined to show any combination of dimensions
and members desired.
The members that are returned in your report can be defined by using a fixed list of members, or even a
dynamic list of members derived by custom logic.
The report to the right shows the quarters of the year, but with just a few clicks any level of the
Time dimension could be displayed in their place.
Our Trend Report example contains a dynamically returned breakout of members from the Product dimension
in the top rows, followed by a fixed set of our Income Accounts giving us a Product Income Trend Statement.
This is just one example of the powerful Trend Reports all of your users will be able to create using Callisto.
|
Preserves all Excel functionality - Callisto reports provide
unmatched flexibility by allowing users to manipulate any Callisto report
without having to worry about disrupting the reports interaction with the
Application Data. Within the Callisto reports users can insert rows and columns
any place desired, define Excel calculations in any location, as well as format
cells and ranges just the way you want using all the Excel functionality.
The native Excel functionality is always preserved by Callisto and can be used to interact with your data, members, or member properties in creative ways only you can imagine. Callisto adds
any changes to the report definition as you edit the report and is therefore able to preserve these
changes in your live Callisto Reports.
|
Consolidating Reports - Place any dimensions on columns or rows.
In this example, the Entity dimension is on columns with a dynamic expansion interacting with
the Control Panel, so the user can navigate anywhere in the database and see a
Consolidating Income Statement for the Entity, Time Period, Scenario, and Product currently selected.
The same functionality makes it easy to see things such as Product Revenue by Entity, where
the Products expand across the columns and the Entities expand down the rows, etc.
|
Variance Reporting - Side by side comparatives with descriptions in the middle are easy
with Callisto. Put descriptions or any other properties any place desired.
|
Guided Investigations - Create reports where a simple double click can be used to navigate
to any alternate view of the data. This allows you to include Guided Investigation paths that make
sense for your data as your users navigate through your multidimensional model.
Users will no longer need to be confused by drilling down many meaningless hierarchy paths trying to find
the path that actually means something.
In the example on the right, when the user double clicks on "Total Revenue", Callisto navigates to the
report showing a break out of revenue by Entity.
And your drills are not limited to Excel. You can include drills to web
systems such as Reporting Services reports, or Sharepoint sites, to allow users
to continue their investigations to any level of detail you want to provide in
your company. |
Shared Library of Reports -
Reports can be organized into a shared library which all users can access.
Administrators will be able to create a common library of standard reports that
insure only one official view of data exists. The standard reports in the shared
library can be used as they are or as templates for
users to create custom reports of their own from. Reports you want to insure are only used as they are
can be protected against changes by others.
|
Report Wizard -
The Callisto Report Wizard contains several column and row templates in a list that can be mixed and
matched in any combination to create new reports in a flash.
Create your own library to provide a rich set of templates tailored exactly the way you want for your
application.
And if a user does not find a template for what they want, with the Wizard they
can use a simple drag and drop interface to create a new report from scratch.
|
|