Power BI and Essbase - Initial Experiments

Please go through my previous post that explains how to connect Essbase with Power BI using the Essbase (beta) connector, if you are getting your hands in the first time.

I have tried connecting to two different ASO cubes and share how Essbase reacts while creating a new model in Power-BI.

power-bi

Initially I have tried connecting the ASOsamp application after loading some random values as shown in the screenshot.

Power_BI_Essbase_Connector_Initial_Experiments

I have tried selecting each dim from the bottom, it generated the table as displayed in the following screenshot.

Power_BI_Essbase_Connector_Initial_Experiments

It started freezing when I select all the dims and made the server to crash (I setup a VM with 8 GB RAM, which is not enough to process the request), considering the ASOsamp is a small application compared to the production applications.

Power_BI_Essbase_Connector_Initial_Experiments

Logs for reference (recreated for this post): https://hastebin.com/esazoyiwix.sql. I prefer not to run it in production and crash the servers.

Then I tried creating very small ASO application and loaded some random data. This time it worked and I was able to get the values as expected.

Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments
Power_BI_Essbase_Connector_Initial_Experiments

If you notice the Period Dimension, the levels represented in Power BI is similar to the Generation that we call in Essbase.

Logs for reference : https://hastebin.com/riqujohufi.sql