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.

Introduction to Cube Designer - Overview

With the Essbase Cloud, we are introducing a new set of functionality for quickly creating Essbase cubes based upon Excel workbooks.  An end user can literally go from an Excel workbook to a fully functional Essbase cube in a matter of seconds.