Using BIonDemand First Time

In this blog, I have tried to explain how BIonDemand can be used to assist with your decision making. Please note that this is not guide to tell you how to use BIonDemand.


I am part time student of "Master of Business in ERP Systems" and three weeks ago I started great unit "ERP Applications". Just google "BCO6181" and you will find us. Now, in this unit we were exposed to BIonDemand. We were advised to think of data, a question and then use this beautiful tool to find the answer. I tried various sample data to learn this tool first.

 Since the birth of my second child on 4th March I have been looking for a new DSLR camera. Now, this is my first DSLR camera so I only needed entry level camera. So I started to read and make some nice excel sheet with the data. Hang on, excel sheet with data. There we go, I can use this excel sheet to assist me finding good entry level camera. So I chose following three vendors and metrics.

 Model
Canon
Nikon
Sony

 Metrics
Mega pixels
Sensor Size
Auto Focus Points
ISO
Frame Rate
LCD Monitor
Price

 Just a personal advise, I am not expert with cameras but what I read explains that mega pixels is not the only thing you should be looking for. There are many factors. One of the them is right lens. Therefore, I decided to just look for camera body. Hopefully, once I have got hands dirty on BIonDemand with above data then I will try to work with lens and camera data together. Oh, also DSLR stands for Digital Single-Lens Reflex. ;-)

 Now, back to learning. So I made excel sheet in following format



Next steps, I uploaded the data set from excel file and follow the easy prompts/guide to create my own visualization. I added all the visualization to My Dashboard (front page). Please see below.





Later, when I was creating a new visualizations I wanted to add more measurements and do more with it and then I found there was a link saying "change look and feel (beta)". Guess what, it opened the "Xcelsius". Unbelievable, I am starting to love BIonDemand. So, once again I played and created following static dashboard.

I must say that I loved BIonDemand so much that I am going to advise to everyone. So get on it and try different things. Anyone can do this but you should know your data well and have right questions in mind (as suggested by Tony De Thomasis). Now, I am going to play more with it and finish my home work.
Location: Melbourne VIC, Australia

Comments

Post a Comment

Popular posts from this blog

SAP HANA Input Parameter - Derived from Table - Use Expression in Filter Value

Image
Recently, I have experienced something while modeling HANA information view that I want to share with everyone.  Case:  Dynamic Filter for projection with current Fiscal Year and Fiscal Period.  Method: There are different parameter types that we can use to do this. I decided to use following "Derived from table" type as shown below:  Challenge: When filtering column then it displays list of values from the same HANA information view and we can select the date. Now, as the requirement is current Fiscal Year and Period so how do we filter the column to dynamically select current date in "Filter Value" section? Solution: Like everyone, I expected it to understand the expression. So I tried following and it worked. I used the expression  currentdate() I was aware that I could use expression in the "Default Value" section (as explained in SAP HANA Developer Guide) but didn't expect it to work in "Filter Value".
Read more

SLT Replication Issue Due To Timeout Reading Logging Tables

In our company we use SAP LT (Landscape Transformation) replication server to replicate tables from SAP ECC system to SAP HANA in real time. SLT creates trigger for each table that we want to replicate and whenever there is change it stores the changes in the logging table. Later on, these tables are used to update replicated tables in SAP HANA.    This system is really useful when you really need real time replication to SAP HANA. However, it also causes performance issue if proper monitoring is not being performed. Just recently, we faced an issue where we were trying to replicate a large table "VBFA" to SAP HANA in production environment. Every time table replicate status changes to "ERROR" after the initial load. It started to fail when ever SLT tries to read change/delta stored in logging table. This tables replication worked fine in DEV and QA environment.   After troubleshooting and taking help from SAP support we found that in the program generated
Read more

SAP HANA Content Security Roles Setup

Image
A few months ago I was given a task to implement content security in SAP HANA. The main purpose for this task was to provide Business user access to information models created in SAP HANA. For example Finance user should only view finance package and can access information models in that package via BI tools such as Analysis for excel. So, after a research and few discussions with various people (one of them was from SAP Melbourne) I came up with following security model. Let's assume that content is maintained in following structure: So based on each type of privilege I created the roles as shown below: System Privilege Roles These roles are mainly needed for System admin tasks (technical role) X_HNS = S for System Privilege role Role Name Privilege Type Assigned Privileges X_HNS_USERADMIN This role can create users, change their passwo
Read more