What is cube?


The cube is in the center of multidimensional Analysis.
It can be database or multidimensional database. The cube is consisted of levels, measures, dimensions and hierarchies. It is a method to store data as multidimensional type. The measures are categorized by dimensions. The cube is designed by business logics because it used in OLAP is usually used to analyze the high-level analysis by business users.




 
<http://blogs.technet.com, Insufficient data from Andrew Fryer>

   On-Line Analytical Processing (OLAP) is actually about business, it just sounds like a science project. ​- Hugh McLeod     



*Short explatation for OLAP

OLAP(Online Analytical Processing) is a strategic method to analyze big data by multidimensional analysis. There are two types pf OLAP as below.

1) MOLAP
MOLAP(multidimensional online analytical processing) indexes directly into a multidimensional database. It processes data that is already stored in a multidimensional array in which all possible combinations of data are reflected, each in a cell that can be accessed directly.

2) ROLAP
ROLAP(Relational online analytical processing) performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard). It accesses data which is the one most commonly used in other OLAPs. It can also generate SQL queries to perform calculations when an end-user wishes to do so.

Comments

Post a Comment

Popular posts from this blog

[Introduction of BI MATRIX's Solutions] Integrated BI Solution, MATRIX Suite

Image
Integrated BI Solution, MATRIX Suite MATRIX Suite is a collection of BI MATRIX's flagship solutions. It is a BI suite that integrates various functions such as dashboard, OLAP, simulation, and self-BI into one platform. Scope of application of MATRIX Suite Integrated BI solution MATRIX Suite enables fast information flow, shortened analysis time, and wider scope of business so that users can utilize BI information for their own purpose. "Do you want to know what solutions and features are included in the MATRIX Suite? And how they are used?" ▶ Product Component MATRIX Suite integrates BI MATRIX's flagship products i-MATRIX, i-CANVAS and i-BIG in a single architecture. - i-MATRIX : User-centered BI solution optimized for creating complex structred reports - i-CANVAS : BI Solution optimized for creating beautiful EIS / Dashboard - i-STREAM : Advanced analytics (Statistics, Data min...
Keep reading

BI MATRIX, won 'TOP 10 LOW CODE NO CODE SOLUTIONS PROVIDERS' selected by APAC CIO Outlook

Image
  Today, I want to share an article published in the 'APAC CIO Outlook' Magazine. This is the annual listing of 10 companies that are at the forefront of providing Low Code No Code solutions and impacting the APAC industry. And, BI MATRIX won this award. <AUD Platform, low-code integrated UI development solution> "Its flagship product, the Automated UI Development (AUD) platform, is a low-code integrated UI development solution with a software bot enabling end-users to build systems without complicated coding skills." "These functions enable users develop business systems using drag-and-drop techniques and minimized coding." <Main feature of AUD Platform> "This allows even business officials to swiftly make HTML 5 web reports by easily designing a report form in Excel and simply clicking the conversion button." "AUD Platform caters to the workforce shortage in the IT sector, as it requires fewer developers than traditional system d...
Keep reading

BI MATRIX, an agency contract with Hitachi High-Tech Solutions Corporation in Japan

Image
 (Left)BI MATRIX CEO -Bae Young Geun,  (right) Hitachi High-Tech Solutions General Headquarters -Takashiro Hirabayashi The BI MATRIX signed an agency contract with Hitachi High-Tech Solutions Corporation (JAPAN) at the head office in Tokyo, Japan, on September 10, 2018. Through the signing this contract, Hitachi High-Tech Solutions Corporation, is not only  selling BI MATRIX solutions in Japan, but also committed to creating a 'LONG-TERM CLOSE PARTNERSHIP' with BI MATRIX. ※ Hitachi High-Tech Solutions Corporation Hitachi High-Tech Solutions Corporation (https://www.hitachi-hightech.com/global/about/corporate/group/hsl/ ) an affiliate of Hitachi High-Tech Group in Japan, is a global company that designs/manufactures/sales of instrumentation and control devices and related software development and solution sales.
Keep reading