Use Case Accelerators > How to Perform Horizontal Pivoting (Denormalization)

How to Perform Horizontal Pivoting (Denormalization)

Article #: Product: Version:

Summary

Denormalization of data is useful for business intelligence reporting, and can be accomplished using horizontal pivoting via one of the following methods:

Resolution

Data denormalization can be achieved in DMExpress using two different methods depending on whether or not you know how many new columns will be generated. Both solutions are included in the attached example.

Attachments

63_HorizontalPivoting.zip, compatible with DMExpress version 7.12 or higher

Additional Information

For See
details on the First and Last functions Aggregate dialog in the DMExpress Help
details on user defined values and functions User defined values and functions in the DMExpress Help
details on direct data flows Direct data flows and performance in the DMExpress Help as well as Best Practices When Using Direct Data Flows
the inverse solution How to Perform Vertical Pivoting (Normalization)
Last updated: