Updating data

BusinessIntelligencePlus provides a procedure and an External Object with the necessary methods to upload the new data of the application to the cube called "BusinessIntelligencePlusUploadData".  According to your business you can define when this procedure is going to be executed in order to upload new data.

The process that you need to do is defferent between Java and .Net.

Updating Data in .Net

UpdatingDataImg01

As you can see this procedure has the 'Call Protocol' property set to  "Command line", so you can create a Windows Scheduled Task or script to update automatically the data of the application as often as needed. 

The steps to update the data of your cubes are the following:

Step 1

Copy the data from the BusinessIntelligencePlus<NAME_CUBE>Data procedure to BusinessIntelligencePlusUploadData.

Step 2

Uncomment the following code replacing <NAME_CUBE> with the name of your cube:

UpdatingDataImg02

Step 3

Execute in the Command Prompt the generated .exe located in the bin folder of your application:

UpdatingDataImg03
 

UpdatingDataImg04

Updating Data in Java

UpdatingDataImg05

The steps to update the data of your cubes are the following:

Step 1

Some jars are needed to run the procedure, so copy and paste the following jars from \web\drivers to the \web folder.  

UpdatingDataImg06

These jars are included as files in the KB so they will automatically included in the deploy of it (for example in the webapp Tomcat folder)

Also, they are automatically included in the Classpath of the Generator:

UpdatingDataImg08

Step 2

Copy the data from the BusinessIntelligencePlus<NAME_CUBE>Data procedure to BusinessIntelligencePlusUploadData.

Step 3

Uncomment the following code replacing <NAME_CUBE> with the name of your cube:

UpdatingDataImg09

Step 4

Replace the tag <NAME_KB> with the name of your KB:

UpdatingDataImg11

To run the .java by Command Line, open a Command Prompt in the web folder of your application and copy the previous line:

UpdatingDataImg10

UpdatingDataImg12