cancel
Showing results for 
Search instead for 
Did you mean: 

Web Intelligence report - Combing 2 reports in one

former_member194139
Participant
0 Kudos
135

I've Two reports both having Multiple data providers and merge dimensions. Created both against same universe.

Now the requirement is to create webi report 4 dimension columns and 2 measure/calculated fields from report1 and 1 measure/calculated column from report 2.

FYI: Report also has the same 4 dimension columns in report 2.

I followed below steps.
Took report one as it is and added extra data provider from report 2 and added the measure /calculated column from report2.
But I'm getting incorrect records when I compare the calculated column with report 2 calculated column.

As I said before, Report2 has the merge dimensions, this might be the reason I'm getting incorrect records.
Can Gurus Please help me. its urgent, appreciate your help. Thanks in advance.

TammyPowlas
Active Contributor

Thank you for your question

Please note I updated the main tag to WebI

Please be more careful when selecting tags in the future

View Entire Topic
amitrathi239
Active Contributor
0 Kudos

have you merged the report 2 dimensions with report1 existing dimension objects after adding Report2 queries in Report1?