Thursday, June 28, 2018

Can we visualize zigzag?

Yes, you can
Remember the zigzag calculation that I introduced in one of my previous posts? If not, you should read it and build the cube as described in that post. Let's try to visualize it using DV.

I assume you already have an OAC instance and know how to log in. First we will need to define connection to OAC Essbase. Click on "Create" button and the click Connection, then pick Oracle Essbase

In the dialog  enter connection name, DSN, User name and password.
Please note that your URL should be of the form: https://YOUR_OAC_URL/essbase/agent

Click Save button. The system will verify the connection and if all the details are correct the connection will be created. Now we need to create a Data Set. Click "Create" button again, but this time choose Data Set.
It will show you the list of the available connections. Pick MyEssbase (the connection that we just created). The system should show the Data Set creation wizard.

Pick Zigzag.demo cube and click "Add". Once data set is created click "Create Project". It will open the project area. Look on the left side.

You should see Zigzag.demo cube and 5 folders under it. There is one folder for measures called "demo" (the same name as the cube) and 4 dimension folders (one per each dimension). Under demo folder you will find all the measures and each dimension folder will contain a column per each dimension's generation. The system will skip generation 1.

Let's expand demo and Time folder. Select "Opening Inventory", Shipped, Received, "Closing Inventory", "Gen3,Time" and drag and drop it into visualization canvas

This visualization doesn't look good to me. Let's change visualization type to combo
move all the measures under "Values"

and change Received and Shipped to be bars
I got this nice visualization

No comments:

Post a Comment