Developing Essbase Applications

Developing Essbase Applications

by Cameron Lackpour
Released June 2012
Publisher(s): CRC Press
ISBN: 9781466553316

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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 Secrets
    • —Dan Pressman describes the previously unpublished and undocumented inner workings of the ASO Essbase engine.
  • Authoritative Experts—If you have questions that no one else can solve, these 12 Essbase professionals are the ones who can answer them.
  • Unpublished—Includes the only third-party guide to infrastructure. Infrastructure is easy to get wrong and can doom any Essbase project.
  • Comprehensive—Let there never again be a question on how to create blocks or design BSO databases for performance—Dave Farnsworth provides the answers within.
  • Innovative—Cameron 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.

Table of contents

  1. Front Cover
  2. Contents
  3. Foreword
  4. Preface
  5. Acknowledgments
  6. What Is This Book?
  7. Contributors
  8. Chapter 1: Building the Foundation: Essbase Infrastructure (1/5)
  9. Chapter 1: Building the Foundation: Essbase Infrastructure (2/5)
  10. Chapter 1: Building the Foundation: Essbase Infrastructure (3/5)
  11. Chapter 1: Building the Foundation: Essbase Infrastructure (4/5)
  12. Chapter 1: Building the Foundation: Essbase Infrastructure (5/5)
  13. Chapter 2: Slay Bad Data in Essbase (1/10)
  14. Chapter 2: Slay Bad Data in Essbase (2/10)
  15. Chapter 2: Slay Bad Data in Essbase (3/10)
  16. Chapter 2: Slay Bad Data in Essbase (4/10)
  17. Chapter 2: Slay Bad Data in Essbase (5/10)
  18. Chapter 2: Slay Bad Data in Essbase (6/10)
  19. Chapter 2: Slay Bad Data in Essbase (7/10)
  20. Chapter 2: Slay Bad Data in Essbase (8/10)
  21. Chapter 2: Slay Bad Data in Essbase (9/10)
  22. Chapter 2: Slay Bad Data in Essbase (10/10)
  23. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (1/9)
  24. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (2/9)
  25. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (3/9)
  26. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (4/9)
  27. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (5/9)
  28. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (6/9)
  29. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (7/9)
  30. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (8/9)
  31. Chapter 3: Finding the Dirt: Tricks for Rapid Prototyping with Essbase Studio (9/9)
  32. Chapter 4: BSO Will never Die and Here Is Why (1/6)
  33. Chapter 4: BSO Will never Die and Here Is Why (2/6)
  34. Chapter 4: BSO Will never Die and Here Is Why (3/6)
  35. Chapter 4: BSO Will never Die and Here Is Why (4/6)
  36. Chapter 4: BSO Will never Die and Here Is Why (5/6)
  37. Chapter 4: BSO Will never Die and Here Is Why (6/6)
  38. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (1/9)
  39. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (2/9)
  40. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (3/9)
  41. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (4/9)
  42. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (5/9)
  43. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (6/9)
  44. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (7/9)
  45. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (8/9)
  46. Chapter 5: BSO Is Dead. Long Live ASO (Converting BSO to ASO) (9/9)
  47. Chapter 6: Practical MDX for Essbase Developers (1/8)
  48. Chapter 6: Practical MDX for Essbase Developers (2/8)
  49. Chapter 6: Practical MDX for Essbase Developers (3/8)
  50. Chapter 6: Practical MDX for Essbase Developers (4/8)
  51. Chapter 6: Practical MDX for Essbase Developers (5/8)
  52. Chapter 6: Practical MDX for Essbase Developers (6/8)
  53. Chapter 6: Practical MDX for Essbase Developers (7/8)
  54. Chapter 6: Practical MDX for Essbase Developers (8/8)
  55. Chapter 7: How ASO Works and How to Design for Performance (1/10)
  56. Chapter 7: How ASO Works and How to Design for Performance (2/10)
  57. Chapter 7: How ASO Works and How to Design for Performance (3/10)
  58. Chapter 7: How ASO Works and How to Design for Performance (4/10)
  59. Chapter 7: How ASO Works and How to Design for Performance (5/10)
  60. Chapter 7: How ASO Works and How to Design for Performance (6/10)
  61. Chapter 7: How ASO Works and How to Design for Performance (7/10)
  62. Chapter 7: How ASO Works and How to Design for Performance (8/10)
  63. Chapter 7: How ASO Works and How to Design for Performance (9/10)
  64. Chapter 7: How ASO Works and How to Design for Performance (10/10)
  65. Chapter 8: Deep Inside the Essbase Java API (1/8)
  66. Chapter 8: Deep Inside the Essbase Java API (2/8)
  67. Chapter 8: Deep Inside the Essbase Java API (3/8)
  68. Chapter 8: Deep Inside the Essbase Java API (4/8)
  69. Chapter 8: Deep Inside the Essbase Java API (5/8)
  70. Chapter 8: Deep Inside the Essbase Java API (6/8)
  71. Chapter 8: Deep Inside the Essbase Java API (7/8)
  72. Chapter 8: Deep Inside the Essbase Java API (8/8)
  73. Chapter 9: System Automation the Groovy Way (1/8)
  74. Chapter 9: System Automation the Groovy Way (2/8)
  75. Chapter 9: System Automation the Groovy Way (3/8)
  76. Chapter 9: System Automation the Groovy Way (4/8)
  77. Chapter 9: System Automation the Groovy Way (5/8)
  78. Chapter 9: System Automation the Groovy Way (6/8)
  79. Chapter 9: System Automation the Groovy Way (7/8)
  80. Chapter 9: System Automation the Groovy Way (8/8)
  81. Chapter 10: Advanced Smart view (1/5)
  82. Chapter 10: Advanced Smart view (2/5)
  83. Chapter 10: Advanced Smart view (3/5)
  84. Chapter 10: Advanced Smart view (4/5)
  85. Chapter 10: Advanced Smart view (5/5)
  86. Chapter 11: How to Successfully Manage an Essbase System (1/7)
  87. Chapter 11: How to Successfully Manage an Essbase System (2/7)
  88. Chapter 11: How to Successfully Manage an Essbase System (3/7)
  89. Chapter 11: How to Successfully Manage an Essbase System (4/7)
  90. Chapter 11: How to Successfully Manage an Essbase System (5/7)
  91. Chapter 11: How to Successfully Manage an Essbase System (6/7)
  92. Chapter 11: How to Successfully Manage an Essbase System (7/7)
  93. Postscript

Product information

  • Title: Developing Essbase Applications
  • Author(s): Cameron Lackpour
  • Release date: June 2012
  • Publisher(s): CRC Press
  • ISBN: 9781466553316