APOS PUBLISHER
Product Components Used: Bursting Manager, ViewTime Security
Background:
The Oregon Liquor Control Commission (OLCC) was created in 1933 by a special session of the Legislature after national prohibition ended. Oregon is a control state with the exclusive right to sell packaged distilled spirits, which are dispersed statewide from a distribution center in Portland and sold in 243 retail liquor stores operated by contracted agents. The agency is headquartered in Portland with regional offices in Bend, Eugene, Medford and Salem. OLCC's mission is to promote the public interest through the responsible sales and service of alcoholic beverages.
Challenge:
OLCC is continually looking for new ways to better serve the agency and the public with new technology. They were in the midst of migrating to the Business Objects platform from a different environment. The Business Objects environment is working out well but OLCC was looking for a high level security solution for their environment. They wanted to take a proactive approach to ensure the most effective security measures had been implemented as a breach of security would be very costly. With a Business Objects recommendation and some investigation into what the APOS BI Tools had to offer, OLCC contacted APOS Systems for a proactive security solution.
Solution:
OLCC purchased APOS Bursting Manager and APOS View Time Security. These tools had the functionality that OLCC was looking for. "There was no disruption to install the APOS Tools; that was easy," claimed Frank Fraijo, Database Administrator. "It takes longer to learn about everything the tools are capable of and to make sure we are fully utilizing them,” Frank continued.
The Bursting Manager tool enables OLCC to burst, distribute and print all at once. “Bursting Manager will save the accounting staff a considerable amount of time with regards to running and sending out reports,” stated Frank.
OLCC also purchased View Time Security which utilizes business rules to apply row level security to reports. Report content is filtered for the current user; whether running a report now, scheduling a report or viewing a saved report instance. Row level security rules can be applied by user group to facilitate powerful data filtering while minimizing entitlement database maintenance requirements. View Time Security allows OLCC to assign business rules by report name to quickly apply the same row level security to a specific report across all occurrences in all folders, minimizing entitlement data maintenance requirements.
Why APOS?
“APOS support was excellent to work with. They were easy to access and they gave me additional ideas on how to better utilize the software tools that we purchased. APOS is the greatest in supporting their software. I look forward to working with them again in the future."
APOS Systems Inc. is an SAP BusinessObjects software solution provider in the SAP PartnerEdge program. Named SAP BusinessObjects Technology Partner of the Year for the past three years, APOS has been a Crystal partner since 1996. APOS has acknowledged a key SAP BusinessObjects XI and Crystal Enterprise strength - its open architecture - and has designed and developed a variety of add-on solutions that offer customers additional capabilities within the SAP BusinessObjects XI infrastructure.
For more information:
Allan Pym, VP Sales and Chief Operating Officer
519.666.2020 or apym@apos.com