The interrogation of the OLAP CUBE by using multidimensional analyses
Keywords:
interrogation, OLAP cube, MDX language, multi-dimensional analysisAbstract
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.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.
