For me, the Cube Designer is a powerful and natural way to design an Essbase cube. I love the fact I can use the power of Excel to aid me in all aspects of dimension building. However, one of the drawbacks of the DBX paradigm is that it is fairly rigid in it's support for incrementally updating an existing cube. For example, by default you cannot move members from one parent to another in an existing cube.
But there is a way around this limitation. It utilizes a few undocumented features of the DBX process. I will discuss the process for enabling DBX to do everything except rename a member in an existing cube.
Wednesday, September 19, 2018
Friday, September 7, 2018
OAC - Essbase Drill-Through Reports
Essbase drill through reports had various versions in the past years. There were studio drill-through reports, EIS drill through reports and GL drill through reports. All of them served well for viewing the supporting details but all had pros and cons.
OAC - Essbase has a new and easy way to maintain drill through reports and is entirely re-written to solve all the problems for supporting details. As this is based on connections and data sources abstraction, there are many opportunities to innovate and make it a lot better. In this article, we are going to discuss the mappings involved in the drill through reports. In the next article, I will show you how to create one from scratch.
OAC - Essbase has a new and easy way to maintain drill through reports and is entirely re-written to solve all the problems for supporting details. As this is based on connections and data sources abstraction, there are many opportunities to innovate and make it a lot better. In this article, we are going to discuss the mappings involved in the drill through reports. In the next article, I will show you how to create one from scratch.
Subscribe to:
Posts (Atom)