When deploying an on-prem Hyperion planning cube, a native Essbase cube, or refreshing planning cloud database, you may get the following Essbase error. “Cannot restructure cube. Essbase Error(1010004): Total possible blocks of database [xxx] exceeds the limit, which is [2^52], or [4.5036e+15], for each of two dimension groups.” If you check Oracle support…
When Essbase Cloud got released, a new Excel add-in coming with the Essbase Cloud, the Cube Designer. We briefly discussed about the Cube Designer in the previous posts. Now, let’s dig into more details. Basically, we are able to use Cube Designer to connect to Essbase application. It helps us to design, create and…
As we know that Oracle released Essbase Cloud Service in March 2017. Since Essbase is in Cloud, we are able to use MDX to query and manipulate the multidimensional data from cloud now. I think it might be a good time to discuss MDX. Let’s do a quick intro about MDX. Just in…
Back to March 17th, 2017, the Saint Patrick’s Day, Oracle released Essbase Cloud Service as part of Oracle Analytics Cloud (OAC). Well, Oracle likes to release new cloud products on holidays. Lol. I remember Oracle released PBCS on February 14th, 2014, Valentine’s day. I have a related post on the Essbase Cloud releasing…
When we start writing any calc scripts in calculation manager, typically, we will start with the SET commands, which is the housekeeping part. The SET commands are restricted to the certain scripts and make sure the script can run in a proper and efficient way. Today, I would like to go through the major…
When I started my career, and started learning and working on Essbase and Hyperion, I was told that knowing about how the Essbase works, how the blocks work can differentiate a knowledgeable and a terrible Essbase admin. At the beginning, I didn’t think that was a big deal. Until days later, some block related…
March 17th, 2017, Oracle finally released Essbase Cloud Service (EssCS). EssCS is part of Oracle Analytics Cloud (OAC). I do remember the first time I heard of EssCS that was during Oracle Open World 2015. After such a long time waiting, EssCS is finally here. It is a very exciting moment! Oracle Analytics…
As we discussed in another blog, as of now, the EAS and Essbase Studio will not be available in the cloud. But there is still a way to manage the database, and go to the Session Management to kill running processes as we did in EAS. Go to Rules (Calculation Manager), and then click…
I remember when I started my career in EPM/Hyperion, I started on Hyperion Planning and Essbase. On-premises version, I’ve been using Hyperion Essbase Administration Services (EAS) to manage Essbase. I really like this tool. I remember the days that my mentor taught me how to use EAS to load data, how to update hierarchy, how to…