Teradata deski #Multivalue Error

[Former Member]

When refreshing the XIR2+Sp2 deski report with freehand sql data provider with Teradata V2r6 getting #Multivalue error and when editing dataprovider report displays data with out any errors.

Please Assists

[Former Member]

Hi Sasi,

Could you please test the following solutions:

Solution1:

Use slice and dice to reset all the tables that have #multivalue in it. The only problem with this workaround is they have to do the formatting manually.

Solution2:

Also, test the issue by changing the object to dimension if it is a measure or to measure if it is a dimension.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

You can try the following solution to resolve the issue.

To avoid duplicate row aggregation:

1. Select the table, right-click and select Edit Format from the menu.

The Properties tab displays the table formatting options.

2. Select Display > Avoid duplicate row aggregation.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

#Multivalue error is normally encountered when a multi row value is displayed in a single cell.

Please try including the value in a table or add a Max() or Min() function to it.

Regards,

Sanjay