Skip to Content
0

Merge dimension greyed out

Jun 07, 2017 at 11:21 AM

50

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Jun 07, 2017 at 06:18 PM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I did but it doesnt allow me to.

0

Does both Lead_Id's are same data types?.

In WebI, try checking with Isnumber(Lead_Id) function.

If condition is tru for all 3 ID's then, it should.

Thanks,

Jothi

0