Lesson 9 – Create Cube – Prepare Data for the Cube

What will you learn:

Description

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 120 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.

Course Type

120 – Jedox Platform Basics

Duration

03:18 min

Language

English

Speaker

Thomas Arampatzis Sabrina Sebens

Learn More

Get familiar with Jedox as a platform by watching our 120 Platform Basics course, where you can learn how to create ad-hoc reports, customized reports, and set up data models among other things. Don’t forget that you can try out Jedox for yourself for free with a 14-day Cloud trial or for 30 days with a standard trial, and check out the Jedox Blog for some great practical examples and our user documentation resource at the Jedox Knowledge Base.