tag:blogger.com,1999:blog-2343340668306017890.post8953245607262601523..comments2023-06-04T19:48:41.949+05:30Comments on Business Objects: Merge Dimensions in WebiGShttp://www.blogger.com/profile/10409645255065743315noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-2343340668306017890.post-44450759715869631702017-04-27T18:04:36.140+05:302017-04-27T18:04:36.140+05:30Hi ,
When I use the merge, am getting #MULTIVALUE...Hi ,<br /><br />When I use the merge, am getting #MULTIVALUE error in the second query. How to resolve this?Prkshhttps://www.blogger.com/profile/15761615177225916941noreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-30133988192912954882014-03-17T01:31:30.175+05:302014-03-17T01:31:30.175+05:30Hi Ramesh
You need to narrow down the issue by br...Hi Ramesh<br /><br />You need to narrow down the issue by breaking the report into multiple smaller ones.<br />That would be best way to troubleshoot any kind of issue.<br /><br />Thanks<br />GauravGShttps://www.blogger.com/profile/10409645255065743315noreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-81411573210835147932014-03-16T12:25:32.413+05:302014-03-16T12:25:32.413+05:30how to trouble shoot if i have a oracle data sourc...how to trouble shoot if i have a oracle data source and my report everything is correct but my user is not getting correct data of ressult.....rameshhttps://www.blogger.com/profile/11635082277048181039noreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-9546171829529560602014-03-12T16:29:06.294+05:302014-03-12T16:29:06.294+05:30Excellent Blog. Thanks for the effort !!Excellent Blog. Thanks for the effort !!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-28847122052752215872013-12-30T17:29:50.754+05:302013-12-30T17:29:50.754+05:30Hi,
I have summarised the same in the last section...Hi,<br />I have summarised the same in the last section.<br />let me take another example:<br />Lets say you have dimensions M1 and M2, and you merged tham say M3.<br />M1 has values 1,2,3 and M2 has values 3,4,5.<br />lets say you brought revenue also like R1 from query 1 with M1 and R2 from query 2 with M2.<br />In the block when you select M1,R1, it will give you 1,2,3 values and there revenue.<br />If you select M2,R2 it will give 3,4,5 and revenue.<br />If I select M3 than data will be 1,2,3,4,5<br />Note:- extended merge dimension option is not selected yet.<br /><br /><br />Now if ou remember when you used M1 it just shows you 1,2,3.<br />Now check the option "extended merge dimension", you will see all results of merge are shown for this column i.e. 1,2,3,4,5.<br />Eihe of the column M1 or M2 will give you merged results which earlier you were getting either from M1 or M2 based on the object you brought in the block.<br /><br />Hope it clarifies your doubt.<br /><br /><br />GauravGShttps://www.blogger.com/profile/10409645255065743315noreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-55670519829250953962013-12-30T15:00:24.434+05:302013-12-30T15:00:24.434+05:30Can you please put the practical difference of usi...Can you please put the practical difference of using Full outer join using 'Extended Mege Dimension' and 'Merge ID' column?<br />If they are doing the same job what is the exact difference between them?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-18434513672557480572013-12-13T19:14:54.460+05:302013-12-13T19:14:54.460+05:30I Need Material of Combained query of WEBI I Need Material of Combained query of WEBI Anonymoushttps://www.blogger.com/profile/12551128063217710144noreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-78312603850425931012013-12-03T20:18:19.859+05:302013-12-03T20:18:19.859+05:30thanks for the explanationthanks for the explanationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-67116475659110807372013-11-22T21:43:44.002+05:302013-11-22T21:43:44.002+05:30super explanation..Thanks a ton brother..super explanation..Thanks a ton brother..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-69989785601243275972013-10-26T08:46:01.003+05:302013-10-26T08:46:01.003+05:30if You are are getting same result after using mer...if You are are getting same result after using merge dimension and extended merge dimension, then whats use of extended merge dimension?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-91654226768528603302013-06-21T01:07:04.528+05:302013-06-21T01:07:04.528+05:30SOOOOO Helpful, did not know it was an outer join!...SOOOOO Helpful, did not know it was an outer join! Thought it was an intersection the whole time!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-21554142119713108642013-04-02T04:11:49.184+05:302013-04-02T04:11:49.184+05:30liked the way it was explained..
liked the way it was explained..<br /><br /> <br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-66303239673730988612013-03-23T02:08:32.672+05:302013-03-23T02:08:32.672+05:30Thanks a lot....
Thanks a lot....<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-37231436863008585682013-03-05T15:14:14.616+05:302013-03-05T15:14:14.616+05:30Crystal clear!! great job!Crystal clear!! great job!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-12092283649061967322013-01-14T12:28:21.768+05:302013-01-14T12:28:21.768+05:30Thanks....a lot... now I got the clarity of Merge ...Thanks....a lot... now I got the clarity of Merge Dimensions..<br />Pretty explanation.<br /><br />Keep poting more...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-75619434856730787012012-08-09T11:50:04.027+05:302012-08-09T11:50:04.027+05:30Ok.. can you pls let us know How do u link differe...Ok.. can you pls let us know How do u link different data providers in a single report ??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2343340668306017890.post-68979906889325070992012-08-08T21:32:35.340+05:302012-08-08T21:32:35.340+05:30Good job...;)Good job...;)Anonymoushttps://www.blogger.com/profile/09639565827402474479noreply@blogger.com