If you would like to turn on basic authentication for mondrian cubes from excel you need to implement steps below.
Read more
Latest Posts
Protected: Robo advisors in FinTech
How to implement Kylin dialect for Mondrian
In this post I will explain, how to implement Kylin dialect in Mondrian.
Improving performance by reading data with Hive for HDFS using subfolders (partitioning)
In our previous article we have discussed the root structure for HDFS. In this article we will discuss next level of the file structure, which will help to improve the speed of reading data.
Raw, clean, and derived data in data lakes based on HDFS
You may think, that there is no need to structure data in HDFS. You can systemize it in the future. But I think this is a wrong way. We should always keep in mind: there is no free lunch. Therefore it is better to make desicions at the beginning.
Read more
Thoughts about schema-on-write and schema-on-read
There are two approcahes, which we can select for designing storage of the data. They are schema-on-read and schema-on-write.
How to integrate Apache Kylin OLAP In Excel (pivot) [XMLA Connect and Mondrian]
Apache Kylin is very powerfull OLAP engine. It supports ODBC driver to move the data in excel, however this driver is not user friendly. Users should wright sql queries for this.
Short note about HDFS or why you need distributed file system
Why do you need HDFS (Hadoop Distributed Files System)? If the amount of data is small and place on your computer is enough for this, then you do not need distributed file system. But if you like to process a large amount of data, which is not possible to save on one computer, then you need to think about distributed file system.
Documenting your investment decisions in MoneyBuilder
Before you start the investment you need to document two very important points.