Skip to Content
S N

Merge dimension greyed out

I have following table structure where in the I have many to one and one to many joins.

o when I pull objects from all the tables it gave me multiple rows so I created context1 and context 2.

But now when I pull these objects it creates 2 different tables and I cant put all the objects together which I need in the report.

To overcome this I need to do the Merge dimension but when I select all these three Lead IDs its greyed out,is it because of the data type?

Please suggest the best way to pull these objects?

issue.jpg (34.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 07, 2017 at 06:18 PM

    Hi,

    Try merging both Lead ID from Lead _Status and Lead_Applicant table.

    and then do merge with Lead_lead table. Webi usually looks at similar tech names and description.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded