Merged Dimension in Web Intelligence Report

[Former Member]

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

[Former Member]

why did you create two different dat providers ?

Data is coming from two different tables if yes then you can apply join between two tables on field

CFN-380775236 (truncated one) & that will give you correct answer.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

Each of my data provider is a different universe itself which are built on different databases. Hope this answer your query. Please let me incase you need any more input to answer my question. Thanks !

Regards

Kapil

[Former Member]

I think all you need to implement is simply extended merge dimension using that you can display all the values.

check it below: