My first cube

This is a step-by-step explanation of how to create a simple cube using BusinessIntelligencePlus and GeneXus 15 using .NET  and SQLServer. If you are using another generator (Java) or DBMS, the steps are quite similar.

Before we start

For this example you will need:

What Are We Building?

In this example, we are going to develop a Business Intelligence module in order to analyze the sales of a company. The module will be integrated into the web application where the company manages its sales, customers, etc. 
The managers of the company will access and query the cube from a browser. 
 
We will use BusinessIntelligencePlus in order to implement the desired module.

After following this step-by-step guide, you will obtain the following cube:

 

Help, I’m Stuck!

If you get stuck, please contact our support team right here!

Let's start!

By following three simple steps you will be able to create your cube!

1 - Create the Knowledge Base

Create a new Knowledge Base and select C# as Prototyping Language and SQL Server as the database:

MyFirstCube-Img01

Import the TrainingBIPlus.xpz in order to get all the needed transactions for the example:

MyFirstCube-Img02

Run the KB by creating the database using a SQL Server instance.

As you can visualize at runtime. the transactions within this xpz already have WorkWithPlus applied in order to have an amazing UX for our application!

The xpz also contains a web panel so you can easily load some sample data. Run the "WPLoadData"  web panel in order to load each transaction. You should click on each button to load the transactions.

MyFirstCube-Img03

2 - Create the Cube

We are ready to create the cube! You can do it from the Tools menu-->BusinessIntelligencePlus-->Create Cube:

Step 1 - Connection data

In this example, we will use DVelop's cloud in order to create the cube.

So, complete the fields with the following data. 

Important: in this example, we will guide you to query the cube in English but queries are also available in Spanish and Japanese, so you can select your desired language.

Queries in English

  • Cube Name: Sales<Your_Surname> (example: SalesGodin)
  • Server Name: https://services.bip.dvelopsoftware.com/
  • Username: TrainingEnglishUser
  • Password:  trainbip

Queries in Spanish

  • Cube Name: Sales<Your_Surname> (example: SalesGodin)
  • Server Name: https://services.bip.dvelopsoftware.com/
  • Username: TrainingUser
  • Password:  trainbip

Queries in Japanese

  • Cube Name: Sales<Your_Surname> (example: SalesGodin)
  • Cube English Name: Sales
  • Server Name: https://services.bip.dvelopsoftware.com/
  • Username: TrainingJapaneseUser
  • Password:  trainbip

Step 2 - Design the cube

Add the following attributes by setting the proper "Name in Cube" and "Data type in cube" value. Also, in this cube, we don't need to analyze the Sales from Uruguay, so you should set the following condition:

MyFirstCube-Img04

Important: The "Name in Cube" is the value that is going to be used to query that attribute in the cube. So, if you are working in Spanish or Japanese, you will have to define the Name in Cube in your language.

Step 3 - Summary

Confirm if the cube is designed as selected and Finish the wizard in order to proceed with the creation of the cube.

MyFirstCube-Img05

BusinessIntelligencePlus is going to:

  • Impact the new cube design into BusinessIntelligencePlus database
  • Load the data according to the design
  • Import in the Knowledge Base the necessary objects to query the cube.
  • Save the cube in the KB´s preferences so you will be able to edit it later

3 - Query the Cube

In order to integrate the screens where we are going to query the cube with the application, let's add the web panels created by BusinessIntelligencePlus in the menu as follows:

MyFirstCube-Img06

Now we are ready to query the cube! Run the application and access the WPBusinessIntelligencePlusCube web panel. 

As you can see, we have a conversational interface where we are going to query the cube in natural language. Run the following queries:

  • Total Sales<Your_Surname>
     
  • Total Sales<Your_Surname> by Country
    • Comment: besides having data from Uruguay we don't visualize it in our cube as we have added a condition while designing it
       
  • Total Sales<Your_Surname> by Country filtering by "Argentina"
    • Tip: you can filter a query by using the "Filter" icon above it or you can filter all the queries by using the "Set global filters" option:

MyFirstCube-Img07

  • Average import by year
    • Tip I: you can change the visualization type in order to display a grid, other types of charts, etc.

MyFirstCube-Img08

  • Tip II: you can save the query as an image or Excel spreadsheet

MyFirstCube-Img09

  • Average import by year and branch
  • Total import by year and branch and country
  • Max import by month

The queries are saved and displayed on a timeline so you always have the context in which they were executed. In addition, the queries can be saved in a dashboard or desktop so you can have quick access to those queries that are most relevant for your business. To save a query in a desktop, select the following option:

MyFirstCube-Img11

Save some of the previous queries and access the desktop from the menu option to visualize them. You can drag and drop the queries and resize them in order to customize the layout of the desktop.

MyFirstCube-Img12

Wrapping up

Congratulations! You’ve created a Business Intelligence module that:

  • Lets you query by using natural language,
  • Uses state-of-the-art technologies like natural language processing, column-oriented databases, artificial learning, etc.
  • Has a fully integrated UX that matches the rest of the application
  • Let's you save queries into a timeline or dashboard

Nice work! We hope you now feel like you have a general idea of BusinessIntelligencePlus. 

If you have extra time and want to know more, we suggest to read the following: