Skip to Content
Author's profile photo Louis de Gouveia

SAP InfiniteInsight – Explorer


I have not seen much posted regarding InfiniteInsight. I thought I would take some time to demonstrate parts of this product.

InfiniteInsight is predictive analysis tool SAP has acquired form the acquisition of the company KXEN.

This tool is designed to make the process of using a predictive tool easier and with less reliance on a data science. Also everything done is done by just CLICKING AWAY.

When you launch the product you will see Figure 1 as your entry point. In this blog I will focus purely on the explorer part. Explorer is used to get your datasets in a format that we can used to build predictive models on.

1. Explorer.png

Figure 1 – InfiniteInsight

So first step is to create explorer objects, will need to select the source of the data. In this scenario we are pulling from HANA.

2. Connect To Data.png

Figure 2 – Create or Explorer Objects

You can then create your datasets. In my example I have already created the datasets, all done by clicking and no code. I have created three types of data sets.

  1. Entity
  2. Time Stamped
  3. Analytical Record


Figure 3 – data sets

I wont be showing how I created each data set as there is a few screens that would need to be captured and will make the blog too long. Here is a example of the entity data. Data that shows entity that will be analyzed.


Figure 4 – entity data

Example of time stamp data, here we just create time entries.


Figure 5 – Time Stamp Data

The analytical record we have basically taken the time stamp data and joined the entity data, when creating this we can choose what fields to keep or exclude.


Figure 6 – Analytical Record

You can create different versions of the types of data, here I have a second analytical record set. It is the same as the first one except we have added some calculation columns being a sum, count and count distinct. Once again created just with clicks and no code.


Figure 7 – Analytical Record 2

I have also created a third analytical record where we have added extra columns that are pivoted so we can use to analyse even further.

As seen above, the explorer part allows you to get different sets of data and combine them, do counts, pivots and more. Once the data is arranged in desired format you can now move to the next section to predict data on it.

I will try cover that on another blog. 🙂

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      I wouldn't mind exploring this tool. Is there any where we can go to get sample data to use for practice?

      Author's profile photo Louis de Gouveia
      Louis de Gouveia
      Blog Post Author


      If you install the R developer environment you get lots of sample data. You can also download data from several websites, for example KDNuggets

      Hope it helps.

      Author's profile photo Former Member
      Former Member


      You could also get sample data sets from following websites where you have data sets specifically for type of algorithms such as Classification, Clustering, Regression.




      Author's profile photo Former Member
      Former Member


      If you want to practice the scenario presented in the  documentation that comes with the product, you may download the following dataset: the Financial Data from PKDD’99   Discovery Challenge.

      Here are the links to get the data:

      You will find the user guide in your installation folder:

      • document name is ii_user_ADM_en.pdf
      • you should find it under C:\Program Files\SAP InfiniteInsight\WorkstationV7.0.0\Help\PDF\US

      Here is the schema of the database:


      Author's profile photo Raheel KHAN
      Raheel KHAN

      thanks for the above. It would be good if you added some screens around different connectivity options in Explorer to databases like HANA BW as well