Uncategorized

I had the chance to attend the Next Generation Essbase 21.8 webinar a couple of weeks ago. Ekrem Soylemez and Ashish Jain from Oracle gave a preview of Essbase 21.8 and what the future will bring. Many forward-looking statements were made which are covered by Oracle’s standard Safe Harbor disclaimer. Essbase 21.8 is a cross-channel release and […]

I thought about calling this post, “The Meaning of Life: Excel Edition”, as Excel has played such an important part of my life. My lifelong journey with spreadsheets began in college. Back then, I assigned portions of assignments to different members of my group and asked them to give me their work in SuperCalc format.

I just returned, wonderfully exhausted, from an incredible experience at Kscope25. What an amazing week in Grapevine, TX! Sunday Symposiums I kicked off my conference early on Sunday morning at the Essbase symposium. I was glad for the opportunity to meet Ekrem Soylemez in person after he gave his presentation. I’m excited that Essbase is

Shared members are an amazing feature of Essbase but they seem to always present challenges and many of those are not easy to spot. A question arose on the Planning Cloud Customer Connect recently where the issue the poster was having was related to a shared member/alternate hierarchy. For some reason, it’s never immediately apparent that this

The notion that one cannot write complex procedural calculations in ASO was disproved about 10 years ago. I spoke on the topic for the first time at Kscope15. Now that I’m getting more involved in PBCS, I wanted to see if my old tricks worked. I’m going to attempt to use an MDX function in

Essbase 21.6 was released in August. One of the enhancements was improved performance of ASO MDX Exports. In order to use this capability, add the DATAFORMATEXPORT directive to your Export statement. It’s worth noting that this only works for exporting stored data: only Level 0 members and no calculated or formula members. This enhancement removes the limitation of 232 cells that

I will presenting at Kscope25 this year. Usually I present on an established technology or feature, such as how to use the Essbase REST API, advanced drill-through techniques, or containerizing Essbase with Docker. But this year I really wanted to look forward, not back, and what better way than to talk about the intersection of Essbase with AI?

During a recent collaboration session with a customer, our team demonstrated how Dodeca can be leveraged to create a highly flexible and user-friendly solution for managing account-level supporting detail, tailored specifically to customer requirements. The discussion and walkthrough provided a great example of how Dodeca enables business users to work efficiently with Essbase data, integrating

The latest release notes for the connector can be found on the Dodeca PBCS/EPM Connector section of the Applied OLAP documentation site. This bug fix release resolves some issues with ad hoc operations such as when zooming in and using suppress missing, and when the navigate without data option is turned on. Overall retrieve performance was significantly improved in