use of @dpvalue variable after migration form DeskI 3.1 to WEBI 4.1

[Former Member]

Hi all,

I have converted a report DeskI from BOXI 3.1 to Webi 4.1 with Report Conversion Tool.

The conversion is OK but when I refresh the report the result is different .

In the query of report Deski is present the variable @dpvalue in the where condition

(   @dpvalues('( RTRIM(RETEAM.NODO.COD_ORG) ) || '-' || ( RETEAM.NODO.SER_NODO) || '-' || ( RETEAM.NODO.NUM_NODO)',9,242)@dpend)

but in the Webi is trasformed in 

  ( RTRIM(RETEAM.NODO.COD_ORG) ) || '-' || ( RETEAM.NODO.SER_NODO) || '-' || ( RETEAM.NODO.NUM_NODO)  IN  @dpvalue('A', DP0.DOe1e)

The effect in the data is that is present the error #MULTIVALUE

how to correct the variable to obtain the same data?

Bye

ILIO

[CdnConnection]

Ilio,

    Need more information, such as:

• Is the DeskI original query using custom SQL or Universe
• What database and ODBC version being used by DeskI
• What is the exact version of BI 4.1? what SP?
• What database and ODBC version being used after conversion by WebI

Regards,

Ajay

[Former Member]

Hi ILIO,

May I know if you found out a solution yet? I met the similar issue as yours, would be helpful if can get the advise. Many thanks.