Skip to Content

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

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

Add comment
10|10000 characters needed 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

  • Get RSS Feed

1 Answer

  • Apr 19, 2017 at 04:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded