the principle

Does how it go?

Within a database of the type , the data are arranged according to a principle of dimensions corresponding narrowly to the research orientations of the users. This structure in form of “cube” has many advantages. Let us see an example.


A chief of sector can thus wish to visualize a representation of the turnover carried out according to the two axes according to: by product and area and period.
Then, after reflection, he thinks that he will obtain a better appreciation by reversing the axes: by area and product and period.
With a multidimensional basis, it is enough to make “swivel” the cube without to be constrained to generate a new request.
There exists, of course, as a native of other essential functions for the decisional one like , making it possible to cut out a “section” of the cube in order to analyze it more finely and the Seed-planting drill and Drill to go down front in detail.
seed-planting drill:
Thus our chief of sector can put the following question:
Sale of the fresh produce in the Alsace area for the past quarter”
Then he will want to refine:
… And in the department of the Low Rhine
… And in the town of Strasbourg…
… And in the district….

reactualizes the whole of calculations of synthesis and the aggregates according to the put question.



Copyright: Alain FERNANDEZ ©1998-2008- All rights reserved


This site interested you?
Recommend to your friends
Add www.apics-sjvc.org to your favorites





Preferred month
Six Sigma
Reporting
Governorship
Business intelligence
CRM




 

Decisional Open Source panorama of the products


The project BI in 5 times
Business intelligence and decision-making aid
Profitability of the projects BI
KING and TCO
Where are the users?
The post ideal Business intelligence
Business intelligence
Bricks of BI
The project BI, the book
To lead the project

To collect
Collect data LTE
given
BI and

dated
dated
Project Dated
Modeling Dated
Architecture Dated
KING of the project

Why ?
What ?
Model of
New model
design
Test

Essential bricks
Decisional gate
dated
Reporting and
Financial reporting
Instrument panels and km 
Decisional Open Source 

Open Source
The principle of Open Source
Open Source projects
Tools LTE Open Source
tools Open Source Reporting
tools and Dated Open Source
tools Dated Open Source

Resources
Books of BI
Books of Dated
Sites of BI
The project BI in 5 points
10 causes of failure BI




Refer Gate
Glossary
Site map
Contact
By the way…


All the pages of this site are under copyright Alain Fernandez 1998-2008

 


# 070927
# 021180

 
 
 Governorship Sustainable development Performance Management Business intelligence , logistic SCM, km Knowledge management" style="text-align:center">IT</nfw> Management Downloading Effectiveness 

 Project BI LTE Dated Data Reporting financial Reporting BI Open Source