Components of FastCube.Net. Part 2. Chart, ChartToolbar, DataSource, DBDataSet, DTDataSet.

May 19, 2018

Author - Dmitriy Fedyashov

In the first part of the article, we looked at the components for data analysis - a cube and a slice. In the second section, the components from the database or DataTable will be presented, as well as the slice diagram. 1. The Chart component is a graph based on the data from the slice. It is bu...

Conditional data highlighting in FastCube .Net

May 18, 2018

Author - Dmitriy Fedyashov

One of the main tools for data analysis in OLAP programs is "Data Highlighting". This very tool allows you to quickly estimate the "situation", identify trends in deterioration or improvement. In FastCube .Net, the data highlighting is represented in two types: Highlight all cells dependent on v...

From FastCube VCL 2 to FastCube .Net

May 18, 2018

Author - Dmitriy Fedyashov

The name FastCube has occurred, as you understand, from FastReport and the cube. FastReport - a family of report generators for different platforms, and a cube - OLAP structure. The abbreviation OLAP means - online analytical processing. But why the cube? It is simple, if in the usual summary table...

How to create new cube in FastCube.Net

April 4, 2018

Author - Dmitriy Fedyashov

In this article, we'll look at how to create a cube in FastCube.Net using code in a custom application. This question will appear to you right away, when you start working with this library. Well, I hope today we will clarify this issue. The cube file can contain both data and its’ representa...

FastCube.Net components. Part 1. Cube, CubeGrid, CubeGridToolbar, Slice, SliceGrid, SliceGridToolbar.

April 4, 2018

Author - Dmitriy Fedyashov

In this article, we'll consider the components included in the FastCube.Net library. List of components: Cube – the main component that loads a cube from a file and fills it with data; CubeGrid – It is intended for displaying all data of a cube. Visual component; CubeGridToolbar &n...

How to connect database to a cube

April 3, 2018

Author - Dmitriy Fedyashov

Typically, the data in the OLAP cubes are loaded from the database. To fill a cube with data, you need to create a data source. And here I would like to say a few words about these sources. A cube can receive data from: • Database (Data source) - creates a connection to the database; • ...

How to make a simple FastCube.Net cube editor

April 3, 2018

Author - Dmitriy Fedyashov

To view and edit cubes and slices from FastCube .Net, you need a special application that you need first create. Since FastCube .Net comes in the form of a library and components, we can easily embed the cubes editor into your existing WinForms application, or create a separate one, specially for it...

How to make a report based on the FastCube.Net cube

April 3, 2018

Author - Dmitriy Fedyashov

Analysts, when dealing with cubes, sometimes need to generate reports, based on slices. When is it necessary? When you need to make regular reports based on cubes. When you need to export a cube to some popular data format, which is not available in the built-in FastCube.Net export. Built-in FastCu...

Installation of FastCube FMX Trial

April 6, 2016

Author - Dmitriy Fedyashov

Make sure that you have downloaded from the developer's site installation file for your development environment. 1) Run the installer. First you need to select the localization language. Select the desired one and click "Next". 2) The second step is a warning about copyright. Click "N...

Installation of FastCube 2 VCL Trial

April 6, 2016

Author - Dmitriy Fedyashov

To install FastCube 2 Trial you need to download the installation file from the developer site. Run it. 1) The first step is to choose the interface language. Select English. And click Next. 2) The next window shows the license agreement. If you agree with the terms, check the box "I accept the...

Using FastCube for multidimensional data analysis

February 14, 2012

Author - Oleg Pryalkov

On-the-fly data aggregation of "flat" database tables is one of the first tasks faced by information system developers and their users. At the same time it is usually difficult to foresee the user needs in terms of data selection criteria (filters), dimensions in which the data needs to be aggregate...