Skip to Content
0

merge dimension from excel data source and sql data source in webi report

Apr 19, 2017 at 04:50 AM

64

avatar image

Hello Folks,

I have two data source Excel and sql.

Sql have numeric datatype object and excel have alphanumeric data.

Data type is different due to that not able to do merge on web i report.

Any one please guide, How to resolve this issue.

Regards

10 |10000 characters needed characters left characters exceeded

Hi,

For Merging dimensions in WebI common Key is the best option.

Does the 2 sources has any common object?.

You can still report on 2 different data sources just that you cannot expect a merged data in single table.

You can show them 2 different views.

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mahboob Mohammed Apr 19, 2017 at 04:12 PM
0

Hi Jatin,

To be able to merge, the dimensions should be of SAME data type. You can easily change the datatype of column from Excel in the query panel.

Thanks,
Mahboob Mohammed

Share
10 |10000 characters needed characters left characters exceeded