Webi issue

[Former Member]

Hi Guys

I have a scenarios as below

SerialNumber	Type	Value	Delivery
1111	IMEI	22222222	3434343
1111	mobile	33333333	3434343

Need to code logic in webias below

Serial	IMEI	MOBILE	DELIVERY
1111	222222222	333333333	34343434

Is this possible .. i tries but never seems to ..it comes with blank as below

Serial	imei	mobile	delivery
1111	22222222		34343434
1111		333333333	34343434

[Former Member]

Hi dd,

Please use the below logic for the Columns IMEI and Mobile and leave the other columns as is, and you would get then as expected. Please see below sample where it was achieved with similar data set.

IMEI Column=[Value] Where([Type]="IMEI")

Mobile Column=[Value] Where([Type]="mobile")

Thanks

Mallik

[Former Member]

Hi ,

Some how sap note 1339858 works for me and seems perfect. Is Merge is a Union or Join operation ? Becuase for a requiremnt i have seen it as union and for this it look like Join.

Kindly help on this

Regards

DD

[Former Member]

Hi dd,

Good to know that above mentioned note solved your problem.

Merge does a join operation on your queries and you can see Full Outer join behavior on report, when you have "Extend Merged Dimensions" set on Document Properties and show objects from both queries in one block.

Thanks

Mallik

[nscheaffer]

I would recommend having two similar queries.  One would have a query filter where Type = IMEI and then other would have a query filter of Type = mobile.

Then in your report you would create a merged dimension on Serial by right-clicking on Serial from each query and choosing "Merge".  Put that merged dimension on your report with the value from each query.

Read this blog post for some background on merged dimensions and some of the potential issues you may encounter.

http://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/

Hope this helps,

Noel

[Former Member]

Hi Noel,

Thanks i created two queries , one give 10 lines and other gives 5 lines. I merged on Serial number as said..and when i drag the megred Serial no and IMEI and Phone number from two different qeueries it says #DATASYNC error.

Regards

Savy

[Former Member]

This message was moderated.