Skip to Content
avatar image
Former Member

Merged Dimension in Web I and display multiple values

I have 2 Queries - one from Database and other from excel in Web I. I merged the common dimensions between them .However, other objects in query 2 when set as Detail object and dragged results in multi-value error. I do not want try max or sum function to display only single value. Is there a way to display all the values in the report.

Query 1 :

Col1 Col2

P1 IL

P2 KY

P3 FL

Query 2:

Col A ColB

IL Chicago

IL Springfield

KY Lexington

KY Louisville

FL Miami

Merged Col 2 and ColA. Col1 is Detail object of Col 2 and Col B is detail object of Col A.

I tried checking " Extended merge Dimension values"

Result obtained :

Col1 ColA Col B

P1 IL # multivalue

P2 KY # multivalue

P3 FL Miami

Expected Result :

Col1 ColA Col B

P1 IL Chicago

P1 IL Springfield

P2 KY Lexington

P2 KY Louisville

P3 FL Miami

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 02, 2017 at 09:20 AM

    format table-checked the check box "avoid duplicate row aggregation " and try

    Add comment
    10|10000 characters needed characters exceeded