This blog was taken from a blog that I have written on SCN in 2012. These days the product is Lumira. I added the story here today, because I am migrating my old account and want to keep the content alive.
After reading Tammy Powlas‘ blog about Visual Intelligence 1.0.3, I was very impressed by the possibilities of Visual Intelligence. It seemed to be really easy to connect to a universe. Since we have a complete HANA server installed, it seems to be a good idea to test Visi on this system. I would have never thought it would be so easy to connect and create a report that makes it possible to show data in an attractive way.
Click on New Document and after that select the HANA Online option, as shown in the picture below. You are now being asked to submit the credentials of the HANA server. After providing the credentials click on Connect HANA Instance and on the right side the available views will be shown. For my blog I will use the efashion view for measures.
After connecting to the view, you are able to create a new chart. For example, let´s try to create a Tag Cloud Chart and transform it to a Column Chart.
First lets put QUANTITY_SOLD to the word weight box and FAMILY_NAME to the Word Dimension. If we also would like to have an insight in the AMOUNT_SOLD, we can also add that to the word color. This will give us the result as shown below.
Now let’s switch it to a column based chart:
So it is really easy to create a chart and to switch it to the desired design. Aren’t there any negative sides to the program. Well with the addition of connecting to a universe a lot of sources have become available, like (unsupported) SAP BW Connection. But it seems that the options available in the application aren’t complete yet. I haven’t found a way to publish the chart directly in BI Launch pad or another portal. Also it is not very adjustable to change fonts/colors.
But I do like the easiness of the software, the possibilities and the way you can drill down into the data. So it is actually quite easy to fall in love with Visual Intelligence.