Join SAP Busi­ness One cus­tomer, Design Resources Inc., as they share their report­ing sto­ry and lessons learned. This ses­sion is a fol­low up to their pre­sen­ta­tion at the 2017 Biz.ONE Conference.

Across our five sep­a­rate busi­ness­es each with its own SAP data­base, we have hun­dreds of report­ing requests. We will high­light our learn­ings from using basic queries to Crys­tal reports to lever­ag­ing SQL Serv­er Report­ing Ser­vices (SSRS). For orga­ni­za­tions using SQL Serv­er already, SSRS is already installed and avail­able to every customer.

Basic SAP Queries

- We help main­tain over 3500 queries between our 5 SAP databases

- Show­ing how to query­ing the queries – Query Lookup and Text Lookup

- Rolling out our ​“NOLOCK” standard

- Uti­liz­ing query update tracking

Crys­tal Reports in CMC

- We have over 150 sched­uled reports in the Cen­tral Man­age­ment Con­sole (CMC)

- Lever­ag­ing the APOS tools to find sched­ules and edit CMC sched­ules in bulk

- Shift­ing from ​“Crys­tal GUI Link­ing” to com­mand based we saw a 100% improve­ment in speed

SQL Serv­er Report­ing Ser­vices (SSRS)

- Show­case chal­lenges encoun­tered when migrat­ing reports from Crys­tal to SSRS

- High­light­ing speed advan­tages – our main dash­board report now runs in sec­onds vs.minutes

- Sim­pli­fy hun­dreds of sub reports to just a few key queries

- Eas­i­er report edit­ing, since it’s cen­tered around the subquery.

- Straight­for­ward sched­ul­ing by lev­er­ing SSRS data-dri­ven subscriptions.

- Enhanc­ing web-based reports with hyper­links to dynam­i­cal­ly show detail

Speak­er: 

Joe Leimer, Tech­nol­o­gy Direc­tor, Design Resources, Inc.