Client is attempting to load very detailed data from SQL. Within the data source, the accounts are in the columns. How do you set up a connector to recognize the matrixed nature of the source data?

[OSAdmin]

Answer

• On the main properties of the connector, select “Matrix Data” on the data structure type.

• For the Account dimension, select “Matrixed Text” as the Data Type so that the application knows that is one of the fields that needs to be matrixed.

• For each column that represents a different account, you will need to add an additional Account dimension reference as normal for a Matrix load.

Source: Office Hours 2020-10-22 Partner Enablement