Session 6: Integration
Lesson 9 – Create Cube – Prepare Data for the Cube

Over the past five sessions, you’ve covered everything from the concepts that drive Jedox such as OLAP and multidimensional data storage, how to create dynamic reports in both Jedox Web and the Jedox Excel Add-In, and how to create a theoretical data model and then build it. Now you’re at the point where you understand how to build your data model on a small, clean scale, which means you’re ready to dive into building your model from the bigger, messier sources you’re more likely to run into on new projects. In the final session of the Jedox Platform Basics course, you’ll get to know the section of the platform responsible for extract, transform, load (ETL) processes – the Jedox Integrator. You’re familiar with the layout of the Integrator by now, know how to create a project in it as well as how to create connections, can create data extracts and transform them so that they can be loaded into a dimension, and you can create jobs and set up schedules for them. In this lesson, you’ll see how to begin with cube creation, which starts with preparing your data. This session covers dynamic ways to create dimensions, how to populate dimensions with elements and attributes, how to load a cube and all while using different information sources. You start with a connection, extract data from your source, transform it accordingly, load the prepared data, and depending on your needs, create a job and schedule it. Tasks can be set, for example, at regular intervals using the Scheduler. Test your understanding of Jedox’s Integrator by checking out the sample ETL projects, called Integrator Samples, available through the Jedox Marketplace to see more complex projects based on real data.

Get familiar with Jedox as a platform by watching our Platform Basics course, where you can learn how to create ad-hoc reports, customized reports, and set up data models among other things. Check out the Jedox Blog for some great practical examples and our user documentation resource at the Jedox Knowledge Base.