April, 2004

 

APOS Freeware *Yes, It's True, Software, No Charge

We've accumulated a variety of useful tweaks and solutions for Crystal Enterprise™ that we're now offering on our web site. Note that APOS Freeware is provided complimentary and without support.

Visit here to download:

Update User Preferences

Now you can easily update specific preferences settings across all your Crystal Enterprise users at once, instead of changing them all individually.

ePortfolio Events tab

Now you can easily provide users with the ability to add an 'Event dependency' to a scheduled report right from the standard Schedule page in Crystal Enterprise.

ePortfolio Reschedule button

Now you can easily provide users with a 'Reschedule' capability right from the standard History page in Crystal Enterprise.


Why Use the Cascading Feature in Dynamic Parameters? *Cool Tip

Three solid reasons that translate into improved results:

    • better usability

    • updated data

Parameter

Description

Parameter 1

Moulsham Secondary

Parameter 2

Grade 10

Parameter 3

Science

Parameter 4

Biology

    • pertinent information

Imagine that Susan, a school supervisor, needs to view a report about one of her secondary schools and then head into a meeting in 15 minutes to discuss how well the Grade 10 class has performed in Biology, compared against standardized tests.

 

The problem essentially centers on a dynamic parameter (the secondary school) with three cascading parameters defining the multiple dependencies (school year, class type, and subject). Since this is a dynamic list, the information that the user sees could and does change based on changes in the databases.

 

From Susan’s perspective, all she has to do is choose the school by name. There is no need to remember changing codes or other inputs. Once she chooses Moulsham Secondary, Dynamic Parameters first accesses the latest data captured in the data bases, and then displays only the information you’ve defined through cascading parameters in the value lists while selecting a valid combination as a starting point - grade 10, science, and biology. Again, Susan can only choose information pertinent to the configured set. She will not be presented with any other grades or class types, resulting in a clean set of valid data.

 

Cascading dynamic parameters represent a powerful tool for IT personnel to extract dynamically changing information. By manipulating these parameters, the IT department gives its user community the ability to shape how it can view performance. This feature is very helpful liberating information with multiple dependencies.

 

If you want to check out how cascading Dynamic Parameters can help your application, please visit here to request demo download instructions and our current price list.


Case Study - Automated Packaging Systems *Cool Customer

“When we migrated from Seagate Info™ 7.5 to Crystal Enterprise 8.5, we lost a feature that helped us - the ability to schedule a large volume of reports at the same time. Luckily I came across APOS’ InfoScheduler Add-In software tool. It has saved us time and it has surpassed my most optimistic expectations,” recalled Mike Russo, Senior Programmer at Automated Packaging Systems.

 

Tools Used:

APOS InfoScheduler (with Crystal Enterprise 8.5)

 

Background:

A global leader in designing and manufacturing pre-opened bags-on-a-roll machinery used in the packaging industry, Automated Packaging Systems (APS) is known throughout the world for its AutobagŪ products. With over 500 employees in Ohio, West Virginia and the U.K., Automated Packaging Systems also develops turnkey systems for its customers.

 

Business Issues:

• Substantial manual effort was needed to deploy over 650 reports on an as-needed basis

• Substantial manual effort was also needed to schedule over 200 recurring reports

• Power users were not able to deploy reports when their users needed them, threatening to stretch critical IT departmental resources

 

These challenges could easily mean higher cost, misplaced productivity, and additional demands on the IT department because its staff would need to spend time deploying reports that power users were deploying. “Scheduling and deploying the reports was a manually intensive process and took up a lot of our time, because Crystal’s enterprise scheduling functionality is quite limited unless you are scheduling a single report at a time. Our power users in Finance were even more concerned because they could not deploy important reports to other members in time of need.” said Mike Russo, Senior Programmer for the IT group.
 

Solution:

• Use the APOS InfoScheduler Add-In Software tool

 

When Mike Russo found out about InfoScheduler, he wanted to know if this tool would do the job. The downloaded demo version quickly proved that he had chosen well. InfoScheduler turned out to be a quick and inexpensive way to solve what was potentially a costly problem: bulk report scheduling tasks when needed, and at recurring periods of time. InfoScheduler was very easy to implement. It was even more easy to use because it is based on Microsoft Excel. To quote Mr. Russo: “Our power users and IT staff found this Excel-based tool very easy to use. We simply changed a few parameters, changed printer assignments and destinations, hit the schedule button and the job was done. It was that simple.” Security is not compromised in any way because InfoScheduler is built on the client’s Crystal Enterprise environment, making use of the inherent security features available in this platform.

 

Results:

• Protected operational effectiveness

• Saved nearly 20 staff-hours each month deploying reports

 

With InfoScheduler, APS solved the initial problem of deploying mass reports without the need to rework or customize their reporting infrastructure. They were able to deploy reports with minimal disruption all round, resulting in continued operational effectiveness. Now, they save an estimated 20 staff hours monthly deploying over 850 reports because what used to take several minutes to accomplish now takes seconds. “InfoScheduler let us continue our operations despite a major loss of functionality in reporting tools. Not just the IT group, but for the power users as well,” recalled Mr. Russo.


To read the full Automated Packaging Systems case study or view others, visit here.


APOS Newsletters *Now there are 2!

We've improved our newsletter program. More case studies of real customer experiences. More information about what's new in the world of Business Objects business intelligence solutions and enhancement products. In an effort to better inform our customers and partners on APOS products and services. Visit here to change your subscription status to one or both of:

Add-Ins Software News - published every 2 months with a focus on APOS Add-In software and its role in business intelligence solutions.

Solutions News - published every 2 months with a focus on the APOS role in business intelligence, specifically utilizing Business Objects solutions like Crystal Enterprise.

 

Crystal User Group for North America (CDUGNA) *Crystal Event of the Year

We hope you're joining us in New Orleans on May 26-28, 2004 - a number of APOS team members will be there and participating! If you're attending, please look us up at the Vendor Fair where we're showing all our Add-In solutions - with some new add-in solutions being shown for the first time! Visit here for additional information and to register.

 

 As well, please look for these two track sessions we're presenting and participate if you can:

 

Report Bursting - Requirements and Solutions

Presented by: Dan Clements/Warren Kobbeltvedt, APOS Systems

This session focuses on  a discussion of the various ‘report bursting’ requirements commonly seen in today’s enterprise reporting deployments as well as a discussion/demonstration of potential solutions. Attendees will be invited to share their ‘report bursting’ requirements and solutions.

 

Case Studies - Enhancing Crystal Enterprise with 3rd Party Add-In Solutions

Presented by: Dan Clements/Warren Kobbeltvedt, APOS Systems

This session involves a presentation supported by a customer panel. The customer panel participants represent companies utilizing APOS Add-In software solutions to enhance their Crystal Enterprise reporting systems. The customer panel participants will provide information about how they are using APOS Add-In software, their business case for doing so, and answer questions from the audience.

 

Crystal Enterprise v.10 Support  *All Add-Ins Now Released

We're pleased to announce that all of our current products are now released for the Crystal Enterprise v.10 platform.

Visit here to request the demo version of any of our current solutions for the powerful new Crystal Enterprise v.10 platform.


Migrating from Seagate Info to Crystal Enterprise? *We Can Help

Some aspects of migrating from Seagate Info to Crystal Enterprise are challenging. APOS has the tools and experience to assist with common needs:

• convert InfoViews (Seagate Info) to Processing Extensions (Crystal Enterprise)

• migrate existing report schedules from Seagate Info to Crystal Enterprise

• business calendars for scheduling reports

Visit here to request additional information on Seagate Info migration services.



Business Objects Update *Crystal & Business Objects Roadmap

Good news - the Business Objects roadmap shows Crystal Enterprise as the foundation for the future! This direction ensures a strong future for our Add-in tools and protects the investment our customers have made in APOS Add-In software as an affordable way to enhance their Crystal Enterprise systems!



New Features for Current Products *Stay Current

For current release notes on all our Add-in solutions, visit here to login to our new self-service portal, and then Search our new knowledgebase for all articles containing 'Release Notes'. Here are some highlights of recent updates . . .

Distribution Server v.10

'Export' function - now supports the latest Excel formats

Dynamic Parameters  v.10, v.9

History page - now includes a 'reschedule' link that reloads the schedule screen to allow the user to easily reschedule a report

Cascading parameters - now may be based on multiple parameter values; for example, selecting 2 states in parameter 1 will load parameter 2 values with all cities in both states

Multi-value parameters - now allows you to hide the value portion and display only the description

InfoScheduler v.10

Main screen - new, cleaner look with all commands moved to a new APOS menu within the Excel menu

APOS menu - new menu - Login, Logout, Schedule, Email Addresses, Object Search, Clear Folder Cache

Log on - new logon screen separate from the spreadsheet itself

Email Address - now you can lookup/copy/paste an email address from CE user objects

Object Search - now you can find/point to a specific report and load it in one easy step, including it's report id, parameter names, database connections, etc. - a fast track load!

Object Search - now you can find/point to a specific report instance and load it with 1 mouse click, including all the settings used to schedule the original instance

Clear Folder Cache - allows you to refresh cache if a report object is moved during a current session

FTP upload - now supports upload to unsecure FTP site

FTP upload - if 'User Name'/'Password' fields left blank, Job Server's default user name/password used

Instance Manager v.10, v.9, v.8.5

Scan performance - significant performance improvements have been made when selecting instances by any criteria based on dates

Save Column Order - now each user can re-arrange (and save) the columns in preferred order

Use Date Selection on the Client - use the date/time settings of the client workstation for retrieval

Reset Folder Cache - new command to clear the cache to include renamed folder paths

Object Manager v.9

Dynamic Parameters maintenance - now supports multi-value cascading parameters business rules


APOS Suite of Add-In Solutions *Extend Crystal Enterprise

One of our challenges is keeping our customers and colleagues current on the APOS suite of Add-In products as it grows. Visit here to request demo download instructions and our current price list.

Desktop Application Tools . . .

DocAssist - report documentation & repository tool

InfoScheduler - power batch scheduling from Microsoft Excel

Instance Manager - administrator power tool

Object Manager - report promotion, object management, security maintenance

Server-Based Add-Ins . . .

AddressBook Gateway - integrate your addressbook with ePortfolio scheduling

Business Calendars - customized calendars for report scheduling

Distribution Server - email link, email content, failure notification, distribute on alert

Dynamic Parameters - SQL-based, user-specific pick lists, cascading parameters

Instance Monitor - email notification of failed instances

KPI - who is viewing which reports, license usage analysis, server activity monitoring

RunTime Manager - availability time windows for Crystal Enterprise components

View Time Security - row level data security without C++ development

Development Tools . . .

Processing Extension RAD - fast track processing extension development


Frequently Asked Questions

Visit here to see our latest FAQ list summarizing many of the needs our customers have been asking for help with in our various add-in solutions.

 

Suggestions, Requests, Unique Requirements

If you have a unique reporting system requirement, let us know. We love to work on special projects and regularly save our customers a lot of time and money by using our Add-In solutions as a fast-track foundation for a specific customized solution.

 

 

APOS Systems Inc.
Head Office: 1228 Rose Street, Cambridge, ON, Canada N3H 2G3
Tel: 519.653.8537 - Fax: 519.653.8567
Branch Office: 30703 Blueridge Drive #13,  Abbotsford, BC, Canada V2T 6M8
Tel: 604.864.0766 - Fax: 604.864.4291
Email: apos@apos.on.ca - Web: www.apos.on.ca

 

This newsletter is published approximately every 2 months. If you don’t want to receive future newsletters or would like to add someone else to our email list, visit here. If you have any compliments or suggestions, we welcome those too! This newsletter was sent to: {EMAIL}

 

(c) 2004 APOS Systems Inc. All rights reserved. Crystal Decisions, Crystal Reports, Crystal Enterprise, Crystal Analysis, Seagate Info and Business Objects are trademarks or registered trademarks of Business Objects SA. All other trademarks or registered trademarks are the property of their respective owners.