In order to personalise and hence simplify the process of extracting information from data a new approach is needed. Hence DGV was conceived. Put simply DGV is the principal applied by all BI-Lite applications to help you achieve results.
DGV stands for Define, Generate and Visualise, it is the principal which is applied to simplify what would otherwise be extremely complex subjects. By the same token achieving results that would otherwise be too difficult or at best impractical.
BI-Lite CUBE-it Zero implements DGV in order to enable you to get value, results and hence answers from using Analysis Services.
Define
| During the definition phase of building your cube you will essentially describe three things - Where the data physically resides (Connecting to a Data Source)
- Exactly which bits of data to include in the cube (Designing a Data a Data Source Query)
- Of the data included which columns represent "Dimensions" and which represent "Measures/Facts" (Designing the cube structure)
This definition information can be saved to a file for later retrieval and re-use
|
Generate
| This takes the definition specified in the first phase and physically builds the cube in Analysis Services. The data is essentially taken from your data source, and copied into an Analysis Services Cube, but also manipulating it along the way according to how you specified in the definition phase.
|
Visualise
| Having built the cube, we would ideally like to see some reports or graphs. Visualisation allows you to view the cube contents, and slice and dice the data for analysis purposes. In short, ask the data some questions. Although provision has been made in CUBE-it Zero to open up the cubes generated in Excel, in actual fact you can report or visualise the cubes defined in CUBE-it Zero in any reporting tool that is capable of reporting on Analysis Services cubes.
|