October 26, 2013

A picture is worth a thousand words! (Part II)



Hi again.
Remember, from the 1st part of this post, you have Sales, you have Profit & Loss and, most important, you have a demanding boss! :)
We saw how we can easily retrieve CUBRID data into Excel by using the OLE DB Driver and writing some VBA macro code. In this 2nd part of the blog post, we will not write any custom code at all, but we will use only the built-in Excel OLE DB support to achieve similar results.

Btw, let's not forget what we said - "a picture is worth a thousand words"! So let’s try more images and less talk... :)

We will start by creating a CUBRID OLE DB connection from Excel:




Next, we will select the CUBRID View we need to use to show the boss the Sales data (see 1-st part of the post):


Once all these steps are completed, we have our data in Excel:


All is left to do is to create the chart we need. One easy way to achieve this is to select the “Pivot chart” option, in the last step of the wizard:


Of course, you can go on "playing" further with the Sales data – there are no limits -  once you got the right data into Excel, you have so many ways to display it…

And there is one last thing to clarify: how does the data gets refreshed? Well, it’s quite simple – take a look:




That’s it - See you next time – Bye-bye! :)

P.S. Remember, there’s more choices to get CUBRID data into Excel – for example, you can try to use as well the CUBRID ODBC Driver.