Work with Dimensionality in Formulas

Learn how to work with Dimensionality and how it influences formulas within Pigment. Understand the crucial role of aligning Dimensionality for accurate Metric calculations, which is referred to as Source to Target Mapping in Pigment. Learn the difference between a Metric’s structure and a view and gain insights from one of Pigment’s expert Solution Architects when working with Dimensionality in formulas. 

Who should take this course?

This course is designed for technical users. 

Technical users will deepen their comprehension of Dimensionality's impact on formulas, exploring through practical examples how to navigate and apply these insights effectively for aligning Dimensions between source and target Blocks. The course provides a hands-on approach to learning, with activities designed to gain expertise in working with Dimensionality within formulas, empowering technical users to make informed decisions in their data modeling efforts.

Topics Covered

• Showing how Dimensions impact formulas in Pigment.
• Highlighting The difference between changes to a Block’s structure and pivoting the data in a view.
• Explaining the process of Source to Target Mapping.
• Identifying when Source to Target Mapping is required.
• Sharing expert insights from one of Pigment’s Solution Architects on dimensionality and Source to Target Mapping.

Content Type

• On-Demand

Course Duration

About 108 minutes (1 hour and 50 minutes)