Skip to Content
0
Former Member
Jul 02, 2015 at 04:17 PM

Merged Dimension in Web Intelligence Report

34 Views

Hi All,

I have a requirement to display records based on 2 merged dimensions ( total 4 dimension 2 from each data provider) in a single webi report.

Value of 1st merged dimension would be : CFN-380775236-1

Value of 2nd merged dimension would be Truncated value of 1st dimension i.e. CFN-380775236 .

The Purpose of using this truncated merged dimension is because the first data provider has some records where the value of common dimension is CFN-380775236-1 and we need records from second dataprovider where the common dimension value is CFN-380775236-1 , CFN-380775236-2, CFN-380775236-3 etc.


Now what is happening when I merged the report based on 1st dimension then the some records are getting missed.


However when i am using the second merged dimension then all the records coming however the records from 1 first data provider and 2nd data provider are not coming one to one order as shown below.

So can someone help me how i can display all the data without missing any records , also it should be one to one. Can i use both the merged dimensions based on some conditions.

Please let me know if you require any further information on this. Thanks !

Regards

Kapil

Attachments

Image.png (10.6 kB)