Session 6: Integration
Lesson 5 – Create Dimension – Transform to Hierarchically Organized Data

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’ve already seen how the different sections within the Jedox platform work together with one another (such as the Integrator Server and the OLAP Server), know how to create a project in the Integrator as well as how to create connections (connections to Excel and Jedox were shown, but the process is the same for your other options), and you can create data extracts. In this lesson, you’ll see how to transform your extract so that it’s organized in a hierarchy, specifically using a Tree PC (PC = parent child). In the following lessons, you’ll learn even more 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.