Implementing Oracle Discoverer 10g presented by Nick Roppolo
Nick Roppolo Washington B 1:45 pm – 2:45 pm Tuesday
Agenda • • • • •
introduction the problem implementation strategy Discoverer 10g Release 2 questions
introduction Nick Roppolo of Core Ops, Inc. has been consulting on Oracle Applications in a myriad of roles for 7 years. Of those 7 years Nick has been implementing Oracle Discoverer with Oracle Applications for 3 years, working with IT Professionals and their customers to provide a high-value reporting method.
introduction Core Ops, Inc. is a consulting services firm focused on Oracle Applications specializing in implementing and increasing user acceptance of Oracle Discoverer.
Agenda • • • • •
introduction the problem implementation strategy Discoverer 10g Release 2 questions
the problem
Oracle E-Business Suite provides better business information for effective decisionmaking...
the problem • Implementation teams loose sight of reporting requirements during the project • Oracle Discoverer is looked at as a quick fix • Companies go-live without a plan to meet reporting requirements
Agenda • • • • •
introduction the problem implementation strategy Discoverer 10g Release 2 questions
Implementation Strategy Education • instructor led courses • workshops
Administration • maintain EUL • development migration • develop security plan
Architecture • Discoverer version • plus or desktop
Discoverer Success Support • coach client support team • OTJ training
Development • business areas • reports
Implementation Strategy Education • instructor led courses • workshops
Administration • maintain EUL • development migration • develop security plan
Architecture • Discoverer version • plus or desktop
Discoverer Development Success
• business areas • reports
Support • coach client support team • OTJ training
Discoverer architecture
Architecture • select a Discoverer version • estimate user base • determine presentation method Rule of thumb: one Discoverer server for each Applications Apps server.
Discoverer Plus
4i
Discoverer Plus
10g R2
Discoverer Viewer
4i
Discoverer Viewer
10g R2
10g R2(10.1.2) Benefits • • • • • •
OLAP support drag and drop in discoverer plus conditional formatting cascading parameters & optional parameters searchable lists Enhanced Print capabilities
10g R2(10.1.2) Benefits • • • • • •
OLAP support drag and drop in discoverer plus conditional formatting cascading parameters & optional parameters searchable lists Enhanced Print capabilities
Drag and Drop
Searchable Lists
Searchable Lists
Searchable Lists
Searchable Lists
Enhanced Printing
Enhanced Printing
Implementation Strategy Education • instructor led courses • workshops
Administration • maintain EUL • development migration • develop security plan
Architecture • Discoverer version • plus or desktop
Discoverer Development Success
• business areas • reports
Support • coach client support team • OTJ training
Administration • user security policy • development migration procedures • End user layer maintenance The better the administration the better the education.
Implementation Strategy Education
Architecture
• instructor led courses • workshops
• Discoverer version • plus or desktop
Discoverer Development Success
Administration
• maintain EUL • development migration • develop security plan
• business areas • reports
Support • coach client support team • OTJ training
Education • • • •
delivery method audience training environment content Education is the keystone of user acceptance.
Implementation Strategy Education • instructor led courses • workshops
Administration • maintain EUL • development migration • develop security plan
Architecture • Discoverer version • plus or desktop
Discoverer Success Support • coach client support team • OTJ training
Development • business areas • reports
Development • purchase a reporting solution • develop business areas • develop reports There will always be development. It’s up to you how much.
Implementation Strategy Education • instructor led courses • workshops
Administration • maintain EUL • development migration • develop security plan
Architecture • Discoverer version • plus or desktop
Discoverer Development Success
• business areas • reports
Support • coach client support team • OTJ training
Support • use good help desk principles • extend education • educate the support staff What do you do once the experts have left?
Questions?