The interrogation of the OLAP CUBE by using multidimensional analyses

Robert Gabriel DRAGOMIR

Abstract


The present paper proposes to speak about the interrogation of the OLAP cubes, by using the multidimensional analyses. The first part of the paper deals with the dynamics of the business environment, a fact which triggers the necessity of the informatics systems for decision assistance. The second point of the paper is the presentation of the online analytical processing (OLAP). Connected to this point is the declarative interrogation language MDX, which assures the access to the OLAP interrogation, functions, offering us the possibility of defining the calculated members of the dimensions. A few examples show us how they work. In the end, we draw the conclusions, stressing the importance and the benefits of the intelligent solutions.

Keywords


interrogation, OLAP cube, MDX language, multi-dimensional analysis

Full Text:

PDF

References


Lungu, Ion et al. Sisteme informatice executive, Bucureşti: Editura ASE, 2007.

Muntean, Mihaela. Iniţiere în tehnologia OLAP. Teorie şi practică, Bucureşti: Editura ASE, 2004.

Niemi, Tapio, Niinimäki Marko, Nummenmaa Jyrki, and Thanisch Peter. Constructing an OLAP cube from distributed XML data, Eleventh International Conference on Information and Knowledge Management, November 4-9, 2002, McLean, VA (near Washington, DC), http://www.cikm.org/2002/#program.

Niemi, Tapio, Nummenmaa Jyrki, Thanisch Peter. Constructing OLAP cubes based on queries, Proceedings of the 4th Association for Computing Machinery international workshop on Data warehousing and OLAP, November 5-10, 2001, Atlanta, Georgia.

Pardillo, Jesús, Mazón Jose-Norberto, Trujillo Juan. Bridging the semantic gap in OLAP models: platform-independent queries, Proceedings of the ACM 17th Conference on Information and Knowledge Management, California, October 26-30, 2008.

Spofford, G., Harinath S., Webb C. MDX Solutions, Second Edition, Indianapolis: Wiley Publishing Inc., 2006.

Ion-Trifoi, Gigi, Dinte Constantin. Decizia şi rolul său în managementul financiar al întreprinderii, Annales Universitatis Apulensis Series Oeconomica, Universitatea “1 Decembrie 1918” Alba Iulia, http://www.oeconomica.uab.ro/ upload/lucrari/820062/55.pdf.

http://office.microsoft.com/ro-ro/excel-help/prezentare-generala-a-olap-online-analytical-processing-hp010177437.aspx.




Copyright (c) 2011 author

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.


As to respect GDPR, this site do not allow free registation. Please contact us at: ashues@spiruharet.ro

GDPR Policy:

Please read the statement below:
Processing of personal data and free movement of these data

Registering with this site the author agree with the collection, processing and use of his personal data, exclusively within the ASHUES journal.


 

AWARDS 

WILL BE CONFERRED AT THE END OF THE YEAR

To crown and encourage research efforts of the authors, at the end of a year of publishing our journal board will award online the best papers by distinctions:

1. Best Original Paper Award -  for the paper that has brought something completely new in the reader's attention (a new concept, a new trend, a new proposal in research, etc.)

2. Excellence Award - for the most cited paper and visualized in the online environment during the year

3. First, Second and Third Award- for the best documented and substantiated papers during the year

4. Special Award - to award PhD students and postdocs for the most well documented and substantiated paper