Warenkorb
Kostenloser Versand
Unsere Operationen sind klimaneutral

Developing Essbase Applications Cameron Lackpour

Developing Essbase Applications von Cameron Lackpour

Developing Essbase Applications Cameron Lackpour


€12.49
Zustand - Sehr Gut
Nur noch 1

Developing Essbase Applications Zusammenfassung

Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals Cameron Lackpour

If you love Essbase and hate seeing it misused, then this is the book for you. Written by 12 Essbase professionals that are either acknowledged Essbase gurus or certified Oracle ACEs, Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals provides an unparalleled investigation and explanation of Essbase theory and best practices.

Detailing the hows and the whys of successful Essbase implementation, the book arms you with simple yet powerful tools to meet your immediate needs, as well as the theoretical knowledge to proceed to the next level with Essbase. Infrastructure, data sourcing and transformation, database design, calculations, automation, APIs, reporting, and project implementation are covered by subject matter experts who work with the tools and techniques on a daily basis. In addition to practical cases that illustrate valuable lessons learned, the book offers:

  • Undocumented SecretsDan Pressman describes the previously unpublished and undocumented inner workings of the ASO Essbase engine.
  • Authoritative ExpertsIf you have questions that no one else can solve, these 12 Essbase professionals are the ones who can answer them.
  • UnpublishedIncludes the only third-party guide to infrastructure. Infrastructure is easy to get wrong and can doom any Essbase project.
  • ComprehensiveLet there never again be a question on how to create blocks or design BSO databases for performanceDave Farnsworth provides the answers within.
  • InnovativeCameron Lackpour and Joe Aultman bring new and exciting solutions to persistent Essbase problems.

With a list of contributors as impressive as the program of presenters at a leading Essbase conference, this book offers unprecedented access to the insights and experiences of those at the forefront of the field. The previously unpublished material presented in these pages will give you the practical knowledge needed to use this powerful and intuitive tool to build highly useful analytical models, reporting systems, and forecasting applications.

Über Cameron Lackpour

Cameron Lackpour (Chapter 2 and editor) is president and chief bottle washer of CL Solve, an Oracle EPM consulting company. He first worked with OLAP technology in the dinosaur days of mainframe multidimensional databases and saw the Essbase light in 1993. He has been in the consulting business since 1996, creating solutions for customers using Essbase, Planning, and anything else that ties to those two products. An Oracle ACE since 2011, Lackpour is active on OTNs and Network54s Essbase message boards, the ODTUG Hyperion Special Interest Group, the ODTUG Board of Directors, and his Essbase Hackers blog.

Inhaltsverzeichnis

Building the Foundation: Essbase Infrastructure; John Booth
Introduction
Infrastructure Skill Sets
Foundational Hardware and Software Tips and Tricks
Essbase Architecture and Sizing
An Apple a Day
When It All Goes Wrong
Additional Deployment Considerations
Conclusion

Slay Bad Data in Essbase; Cameron Lackpour
Introduction
Bad Data Kills Essbase Databases
Quality Data Equals a Quality Essbase Database
Four Steps to Data Quality and Success
Conclusion
Appendix: The Code

Finding the Dirt Tricks for Rapid Prototyping with Essbase Studio; Mike Nader
Introduction
Understanding This Chapter
Mapping the Data Sources
Modeling the Data Source
Building Hierarchies and Custom Nodes
Modeling and Developing the Cube
Additional Thoughts
Seeping Away the Dirt

BSO Will Never Die and Here Is Why; Dave Farnsworth
Who Should Read This Chapter
Prerequisites
Why BSO, Indeed
What is "Good Performance"
Getting the Most from Multiple Processors
Cache Is King; Know the Basics
Check Your Work
BSO Matters and Then Some

BSO Is Dead. Long Live ASO! (Converting BSO to ASO); Angela Wilcox
Why Would I Convert to Using ASO Cubes?
When Should I Not Try to Use ASO Cubes?
What Is the Easiest Way to Convert a BSO Cube to an ASO Cube?
What about Reporting Cubes?
What Great Things Can I Only Do with ASO Cubes?
So What Great Things Can I Do with Both ASO and BSO cubes?

Practical MDX for Essbase Developers; Gary Crisci
Introduction
Objectives
Housekeeping
MDX Basics
Properties
Functions
Query Structure
Advanced MDX
Time Functionality
Tips and Tricks
Closing

How ASO Works and How to Design for Performance; Dan Pressman
Introduction
Summary: Rules of ASO Designing for Performance
ASO Queries: How They Work
The Bitmap: Its Role and Function
Understanding Aggregations and Slices
Design Alternatives and Their Costs
Tips to Improve Data Loading and Aggregation Performance
A Final Word about Rule R1, ASO Cache, and Memory
Summary
Afterward and Caveat to the Reader

Deep Inside the Essbase Java API; Tim Tow
Introduction
Essbase Java API Object Model
Essbase Connections
Retrieving Data from Essbase
Sending Data to Essbase
Calculating Essbase Databases
Member Information
Getting Member Information Using Member Queries
Summary

System Automation the Groovy Way; Joe Aultman
The Importance of Being Automated
The Automation Landscape
How to Make an Outline Extractor in Seven Easy Steps
Groovy Things about Groovy: A Deeper Look at the Language
Whats Cookin? Groovy Recipes for the Busy Developer
Wrapping It Up

Advanced Smart View; Robb Salzman
Introduction
A Word or Two about the Classic Add-In
Tune Your Reports, Create Efficient Smart View Spreadsheets
Excel Automation
Afterthoughts

How to Successfully Manage an Essbase System; Natalie Delemar and David Anderson
Who Are You?
Purpose
Setting the Stage for an Essbase Project
Go It Alone? Or Not?
Managing Your Partner
Managing Expectations
Managing the Project
Post Go-Live Tasks and Considerations
It Is All about You

Zusätzliche Informationen

GOR013652077
9781466553309
1466553308
Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals Cameron Lackpour
Gebraucht - Sehr Gut
Gebundene Ausgabe
Taylor & Francis Ltd
2012-06-25
445
N/A
Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem sehr guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.