Opinions expressed by the authors of this blog are entirely their own and do not reflect the position of Oracle or any other corporation. Any advice or recommendations discussed on these sites (or sites they link to) are not validated by Oracle.
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