You can use the metadata to determine the data format when there are multiple dimensions on rows or columns.  While the Anaplan display can clearly show when there are multiple dimensions on rows or columns, the cell data export does not provide data for multiple dimensions on columns.

In the view below, the Product dimension is pivoted to the rows alongside the line items.

An example of the Product dimension pivoted in the Module Many Dimensions2 module.  The view shows the dimension along line items.

The metadata mapping to the exported CSV file:

A diagram showing endpoint output mapping to the Anaplan display.

The order of the Rows dimensions in the metadata matches the order of the columns in the CSV file that give the items of each of the row dimensions.


We update Anapedia regularly to provide the most up-to-date instructions.