Menu
Is there any way to create CUBE DIMENSIONS in HBase or OLAP with it? I want to create CUBE DIMENSIONS kind of application with my HBASE or HIVE and connect that with SSAS for reporting purpose, is that possible? If soo please guide me with some links and codes.
I have tried to create cube views in hive and i want to know whether that is possible with HBase.
Thanks...
734
In-memory analytics eliminates the need to store pre-calculated data in the form of OLAP cubes or aggregate tables. It offers business-users faster analysis, and access to analysis of large data sets, with minimal data management requirements.
Modern Developments Making BI Cubes Unnecessary Today, most BI teams run OLAP workloads on columnar databases in the cloud rather than creating data cubes as a separate layer.
there is no OLAP and cubes in Power BI. It uses in-memory columnar database instead.
These cubes are stored in SQL Server Analysis Services (SSAS). Self-service business intelligence tools such as Excel and SQL Server Reporting Services (SSRS) can target these cubes in SSAS, and you can use them to analyze the data from multiple perspectives.
It is quite possible. In fact several attempts have been made in recent past towards the same. See HBase-Lattice and urbanairship datacube, for example.
You might also find this presentation helpful, which talks about Low Latency “OLAP” with HBase.
HTH
193
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
