How to perform allocation with MDX INSERT

What if I told you MDX INSERT can be used for allocations

Unfortunately, no one can be told what the MDX INSERT is. You have to try it for yourself. You take the blue pill, the story ends, you wake up in your bed and do allocations with calc scripts. You take the red pill, you stay in MDX Wonderland and I show you how deep the rabbit hole goes.

MDX Export

How to export dynamically calculated values to a file

In my previous post I talked about MDX Insert which allows you to store dynamically calculated values in the cube, but what if you want to export it into a file? There are a lot of different reasons to do so, but the most common one would be moving this data into a different application. Back in 2016 Gary Crisci explained how it can be done using MAXL and MDX.

The solution proposed in the post did the job, but I wasn't too happy about it for two reasons.

Introducing MDX INSERT

How to copy dynamically calculated values to a stored location

In my previous post we discussed how one can build a dynamic zigzag calculation in Essbase. In this post I will show how dynamically calculated values can be used in stored member calculations.

About Zigzag

Something that Essbase Hybrid engine can do

What is zigzag?

According to Wikipedia a zigzag is a pattern made up of small corners at variable angles, though constant within the zigzag, tracing a path between two parallel lines. 

Great! How exactly it is related to Essbase?

Introduction to Cube Designer - Connections

The Cube Designer is an extension of Smart View and as such, it derives the connection information to the Essbase cloud via the Smart View private connections. During the installation of Cube Designer, you provide the URL to the Essbase cloud in the private connections panel of Smart View.

Essbase Hybrid Calculation Engine

What to expect from your new “Hybrid Cube”

From time to time, I hear different theories about what “Hybrid BSO” is.  Let me start with a very simple statement – “Hybrid BSO” is not a new storage type. In fact, there is no “Hybrid BSO”. We have a not-so-new Hybrid Calculation Engine that works on top of BSO, ASO storage types and transparent partitions.

Introduction to Cube Designer - Extension Deployment

The Cube Designer extension installation files are currently located on the EssCS server and are placed there by the EssCS installer.  They are in a location which can be accessed via URL so that the following standard Smart View process can be supported.