Skip to Content
0

Merged Dimension in Web I and display multiple values

Aug 01, 2017 at 07:35 PM

38

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Aug 02, 2017 at 09:20 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded